[Babase] Queries that run forever
Karl O. Pinc
kop at meme.com
Wed Apr 4 00:30:01 EDT 2007
On 04/03/2007 11:24:01 PM, Tyler Brock wrote:
> Ok, so I'm still trying to figure out why the following query runs
> forever:
>
> delete from rnktypes where rnktype = 'ADFFIX';
>
> I thought it might be because it is referenced in ranks by some of
> the sample stuff i created but then i ran a delete on all of those
> rows to ensure it would not complain if adffix was deleted from
> rnktypes. However this query still runs forever along with my other
> update calls to the ranks table in the database which used to work
> quickly. I have no idea why so I'm going to you guys for help again.
I'll take a look. I probably have something going on in the delete
trigger. I may not care that it takes a long time because it's
almost never that something's deleted from RNKTYPES.
> Karl, thank you for the advice last time but I still have no idea
> what the password for the admin is so I am unable to start these
> rouge processes that have been created. Sorry.
Lacey can help you out.
Karl <kop at meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
More information about the Babase
mailing list