>I have a workstation which is doing a lot of SQL across the net. When those SQL are executed on the server where the tables reside, it's fast. However, across the net, it takes more time for the workstation to obtain the results. I am trying to optimize those queries. In most of those queries, I don't use NOFILTER. Would that be of such a help? All my SQL are optimized as per Rushmore. It's true that between PCs, I have Ethernet 10 and not 100. But, for now, we can't change cards. So, what else could I look for?
Michel,
For a detailed explanation of why "Full Rushmore Optimization" is not always desirable - this seems to be the problem in your case, since you have an index on deleted() - I just submitted an entry under FAQ. The text is also available under
www.geocities.com/hilmarz/english/rushmore.htm.
Regards, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
