General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Sergey,
>Thanks for the code. I run a few tests and clearly IDX indexes are fastest but difference is not too significant for Reindex, Seek and SELECT to use them, IMHO.
I agree for reindex and select without doubt. Seek and update might depend on the app: on write heavy apps the relatively marked speedup might be of value. In one of my seek-heavy apps I switched a few non-structural cdx (already on a RAMDisk) to idx and gained a few percent - nothing much but easy to do because the groundwork for non-structural indices was already there. The biggest boon seems to be not on (string-)compound "helper indeces" but for integer pk and fk's, but *there* I wouldn't forgo the "safety" and automatism of structural indices against manually managed files.
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