Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Right.
Can you take the RI off one of the children at a time and see which is causing the slowdown?
>I have SET('DELETED') = OFF
>I have indexes on DELETED() but not on !DELETED()
>SYS(3054,1) reports full optimization.
>
>>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