>Hi all,
>
>Today I deleted 25,000 records from a 30,000 record table, and packed it. A SQL (40 records) which had been taking <1 sec. now took 15 sec.
>:-(((
>So, I:
>
>a. reindexed. Still slow
>
>b. re-packed Still slow
>
>c. checked every clause in the SQL and matched them with indexes. Still slow
>
>d. Restored the original. Speed was fine. :-))
>
>e. Deleted, speed was fine. :-)
>
>f. Packed - slow again :-((
>
>g. Copied data (5K records) to a temp file, ZAPped and appended.
>
>Speed is now terrific - almost too fast to see. :-)
>
>Question: Why did this happen?
>
>TIA
>Barbara
Try and delete the index, then re-create it again.
Dave
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