General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
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