Re: "Delete From <table>" taking all day
From: Gary Assa <gsa_at_li.net>
Date: 1996/08/21
Message-ID: <4vf0ld$e4d_at_linet01.li.net>#1/1
Date: 1996/08/21
Message-ID: <4vf0ld$e4d_at_linet01.li.net>#1/1
>>I have a 4000 row table that's taking quite a long
>>time to delete. What's going on?
>>Bill Meskill
>
It could also be that you delete/update/inserted into the table, shelled out
and started up a new SQL session. Your previous session would have a lock on
the table. Or someonle else could have a lock. You said only 2 people on server
but is someone in a Form across the network accessing the table. Many
possibilities...
-- ========================================================= http://www.li.net/~gsa/index.html This is my signature file, not part of this mail message.Received on Wed Aug 21 1996 - 00:00:00 CEST