C
ChUIMonster
Guest
Why are you defining a variable inside the loop? That's kind of bizarre. -prefetchNumRecs is very important, 16 is a terrible default that dates from the 1980s. I suggest 10,000. Properly applied FIELDS phrases are also important (and surprisingly effective). Avoiding JOINs is important. The difference when there is no index sounds a lot like the client is doing the filtering. It's bad enough when the server has to do a table scan but filtering on the client would be awful. I was under the impression that CAN-DO() and user defined functions were the only things that currently cause that to happen. I feel the urge to run some tests but I don't see much free time on the horizon 
Continue reading...
Continue reading...