Re: Client/server database performance

Francis Wang (wangf@interaccess.com) wrote: : Hi there, : I'm in the process of gathering real world stories, experiences, : tips on performance problems you have encountered while building : client/server systems and how the problem was resolved. This : effort will eventually culminate to a C/S performance guide. : All contributing sources will remain anonymous. I will post a : summay of all info I received from the net. Your 2 cents contribution : is greatly appreciated. Thanks in advance! I'd like to get the same sort of data for a book I'm doing on Informix database administration. To start it out, my firm's using a home-brew threaded server that looks a lot like what Informix 6.0 is supposed to be when it gets out. We have several thousand canned queries in a massive ESQL/C program and run 12-16 copies of the program. All applications talk to the API using message queues and flat_files for results. This lets us run lots of users against the database without burdening the system with too many back-ends. This monster was developed in QUELL on Ingres several years ago and converted two years ago to Informix. The client programs talk to the servers through c-language calls. Anybody else using such homebrew servers or middleware? -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) "If you believe that my statements Database Administrator represent my company, please send The Tigon Corporation money and I'll send you stock" Dallas, Texas ===========================================================================