I've just fired off a DELETE FROM table command (i.e. unfiltered
DELETE) on a trivially small table but with many foreign key references
(on similar-sized tables), and I'm waiting for it to finish. It's been
10 minutes now, which seems very excessive for a table of 9000 rows on a
3 GHz desktop
I've just fired off a DELETE FROM table command (i.e. unfiltered
DELETE) on a trivially small table but with many foreign key references
(on similar-sized tables), and I'm waiting for it to finish. It's been
10 minutes now, which seems very excessive for a table of 9000 rows on a
3 GHz
On Tue, 2006-09-19 at 15:22 +0200, Ivan Voras wrote:
I've just fired off a DELETE FROM table command (i.e. unfiltered
DELETE) on a trivially small table but with many foreign key references
(on similar-sized tables), and I'm waiting for it to finish. It's been
10 minutes now, which seems
You do not have indexes on all of the columns which are linked by
foreign key constraints.
For example, let's say that I had a scientist table with a single
column scientist_name and another table discovery which had
scientist_name as a column with a foreign key constraint to the
scientist table.
Rod Taylor wrote:
On Tue, 2006-09-19 at 15:22 +0200, Ivan Voras wrote:
I've just fired off a DELETE FROM table command (i.e. unfiltered
DELETE) on a trivially small table but with many foreign key references
(on similar-sized tables), and I'm waiting for it to finish. It's been
10 minutes