>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement