in reply to A profiling surprise ...
The second thing is to see if the data fetch algorithm can be improved to reduce the amount of work needed to find the appropriate data. DB engines are optimized (and incredibly efficient) at finding data given a set of criteria and proper indexes/joins between tables - making use of that power can improve overall speed by several orders of magnitude (just as dragonchild mentioned above)
Michael
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: A profiling surprise ...
by chexmix (Hermit) on May 27, 2008 at 14:44 UTC |