>Hi all,
>I have a question with seek and re-indexing if you have a moment.
>I have this huge table, number of records generally are about say 500,000 or more and I want to search a name or account based on indexes defined.
>I use the - select 0.. Use table.. set order to xxx, to open the table and use seek to find what I want to find.
>It works fine, only after a certain number of inserts into the table, it sometimes(not consistent) does not find what I inserted until I reindex the table.
>How can I improve my situation WITHOUT having to reindex?
>Please advise.
>
>Thanks!
>Sunny
Indices have an unfortunate tendency to get corrupted. It might help to use the FLUSH command after doing changes. It is also usually considered safer to turn off write buffering on your hard disk - but this will also make the performance of your computer in general suffer.
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)
