Re: Informix in WAN - opinions wanted

Erik Steffl (steffl@softec.sk) wrote: : Hi, everybody, : we are planning information system for about 160 site, : each site has its own LAN with at least one Informix 7 database : server. We need these severs to communicate and share some data, : though batch processing will suffice and data flow will not be : extreme (500 KB or less each day). If we use dial up lines and : Slip protocol (and TCP/IP over it, of course), what Informix : tools should we use? : Is remote access to database tables OK? Is it secure - what : if we update some table and the line goes down - is transaction : usage enough to make our data consistent (to maintain integrity)? Two-phase commit allows a transaction to be transparent on all database servers involved. Data integrity is ok, but transmission it's wery slow. Transaction with about 3 inserts/updates from one DB to another willt take about 3-5 seconds or even more with 9600 speed. To improve speed, I can recommend to exchange data between servers within a single transaction. Faster, but more complex way to syncronize data is mailing some text files in unload format (or more complex, to syncronize several multiple-table transactions in proper order) from one daemon to another. I've used both - 2PC and mail. 2PC gets more consistency, mail - more speed. WBR, Vadim J. Nikitin