Re: Optimizing SE databases.

Posted in 1997

Noble Systems Corp. — Mon, 31 Mar 1997 02:16:35 GMT — source: Informix-list mailing list archive (1991-1998)

raj@innocent.com (Rajendra Singh) wrote: >ngall@stratis-caribbean.com (Edmund Nigel Gall) wrote: >>I'm trying to optimize a client's system for an A/R batch update they >>run at night when no other users are on the system. It currently takes >>5 hrs to update a few hundred records (less than 500 in number). This >>is unacceptable on a single CPU 166MHz server, with more than enough >>RAM! >Maybe the SQL needs optimizing, not the database engine! Absolutely! Based on my experience with SCO/Informix, there should be no earthly way that an update of a few hundred records would take 5 hours. That's ridiculous! Look at a) the code and then b) the table indexing used. >-- >Mr. Rajendra Singh, B. Sc. (Rajendra_Singh@msn.com) >"What is understood need not be discussed." - Loren Adams