Re: Slow JOINs on SE

In article <3rhsl2$j57@ixnews3.ix.netcom.com>, foy@ix.netcom.com says... > > We are porting a product from Oracle7 to InformixSE, and are seeing >mojor performance hangups with SELECTs involving a view or involving a >join. It takes around 10 seconds for a response against a view that >involves 3 tables, each with less than 10 rows. The joins are against >indexed fields. We see the same problem on our InformixSE for Windows >platform, and on our customers RS/6000 platform. > >Is this performance a known problem? Tech Support says that SE is just >slow, and suggest that a $20K upgrade to OL will solve the problem... > You don't mention the version that you are on. 10 seconds is one hell of a long time, SE ain't that slow. Tables with only 10 records will query more efficiently if you drop the indexing as a sequential read is quicker. Have you tried the explain utility in sql- If the costs are low then try checking your disks. Are your tables on heavily used spindles? You could be i/o bound. -- Peter Tashkoff Auckland, NZ