RE: query performance SE vs IDS

-----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Obnoxio The Clown Sent: Friday, January 02, 2004 1:13 PM To: informix-list@iiug.org Subject: RE: query performance SE vs IDS Dirk Moolman wrote: >> OB wrote: > >>What you're seeing is pretty much par for the course. Another place where > IDS will run better is if the tables are really big. But you have to >>remember the code path for SE is much shorter than IDS, you'd probably >>find >>on this sort of query with a small database that SE would be faster than >>OnLine would be faster than IDS 7.x would be faster that 9.2x or 9.3x. One >>key point -- is your filesystem journalled? If it is, try making a raw >>partition for IDS and see if that isn't just a tiny bit faster... :o) > > Interesting point - IDS9 would probably be faster if the table was really > big (millions of records ...?) - built for size and complexity >How is this different from "Another place where IDS will run better is if >the tables are really big." ? :o) Now where did I leave my pills ? Happy 1972 everyone :-) (from the Alzheimers Society) .... I am losing touch with reality here ... time to take the red pill ... ________________________________ << ella for Spam Control >> has removed 283 Spam messages and set aside 0 Newsletters for me You can use it too - and it's FREE! www.ellaforspam.com sending to informix-list