General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Fabio,
>Attention, .idx can to be 2X faster.
usually if I am in need of speedier index I create a temporary index in a ramdisk (helped a lot in NT4, less in more current OS). Since I want to keep things simple for possible transaction and/or datasession scenarios I also use compound indices here - but since this is for speed, I might reconsider and add a way to branch out to use idx. Have you found any rules of thumb under which circumstances (rushmore or seek() ?) the idx is faster ? Perhaps even how much gain can be estimated ? Any hypothesis as to reason ?
regards
thomas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only