Re: Help! Poor performance

This is a multi-part message in MIME format. --------------226D22E319F4 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jeff Craig wrote: > > I can sequentially scan 7.8 million rows in 45 minutes - not good! Greg wrote: > 3. Make sure customer is fragmented across at least 8 dbspaces, more is > probably better. Easily the most important advice of all that provided. This is far and away, in my experience, the most common cause of disappointing performace for folks using 7.X OnLine. Without fragmentation, there is very little that can be parallelized. Parallelization is the KEY to performance with 7.X. Without it, you are likely to get performance no better, and possibly worse, than 5.X.. Dave Kosenko, Informix Professional Services *********************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney --------------226D22E319F4 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="Disclaim" ************************************************************************* Disclaimer: All opinions expressed in this message are well-reasoned and insightful; needless to say, they are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. --------------226D22E319F4--