>The goal is to improve the performance of some very slow REPLACE, SELECT, and LOCATE statements whose performance is terrible on these large tables. The methods that I'm trying to improve performance on are preexising and I'm not trying to rewrite them..I'm just trying to speed up the slowest parts of it and indexes seemed the natural way to improve the performance.
>
>As far as the real reason behind using such a large index..I have various information during various parts of the program and thus need to find a way to "search" through the views on different criteria...
huh? locate for command is fast if there are all aprropriate indices that match left part of index expression.
and i think that locate for field1=key1 and field2=key2 will be blazingly fast when there are indices for field1 and field2 and index on deleted().
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer
