Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Bret:
Do what is SET('DELETED')=?
Do you have an index on !DELETED()?
Have you turned on SYS(3054,1) to check rushmore optimization?
>I need to delete a large portion of a parent table which has some child tables. RI is set to cascade these deletes. The delete processes very slowly and never seems to finish. It looks like
>
>DELETE FROM mytable WHERE mytable.group <> "rightgroup"
>
>I have indexes on all the keyfields and on the group field. The main table has about 5000 records, and the two child tables have a few thousand and several hundred each.
>
>I did this before without any trouble. I don't remember what I did differently, except that I was using vfp3 instead of vfp6.
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