Re: Informix SE 7.2x Performance Problems - Limitations?

From: <aw@topsystem.de> > >We have customer that runs a SE-7.23-Server on a Siemens RM600-420 (Reliant >UNIX 5) who has severe performance problems. There are about 10 users with >up to 3 connections from NT-Workstations. 'The database design does not >include relationships but the applications use a lot of joins, longer >transactions and a lot of read access. The major, number one thing to do with SE is to make sure you have the right indexes. >In our company we also run a SE 7.23 on Linux (old Pentium Pro 200!!) and >an >Online Server 7.31 on NT as our development environment. Both DBs run fine, >although the number of UNIX-system calls on our LINUX-system is much higher >than on the customers Siemens-system for a special action, most database >operations take much more time on the customer's system (factor 5-20!!!). > >We didn't find any information on the web about SE-limitations or tuning. >Maybe you know a source or have your own experiences concerning SE >performance and limitations. > >When does a SE database make sense? > >Thanks >Axel Weitermann >topsystem GmbH > > > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.