Under the Information - Locks in the database manager I see row Locks 312776 Table Locks 6487
These seem kind of high for what I'm doing. How do I prevent these from occurring? Thanks, Mark -----Original Message----- From: Becker, Holger [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 4:48 AM To: 'MaxDB - Mailing List'; [EMAIL PROTECTED] Subject: RE: Delete Takes a very long time mailto:[EMAIL PROTECTED] wrote: > I have my app almost complete on MaxDB. I have just run > into a major snag > and would appreciate any help you can offer. > > I have a table "Files" that has about 400,000 rows > > If I run queries like > 1) SELECT * FROM FILES WHERE FILE_NAME = "THISFILE.TXT" > OR > 2) SELECT * FROM FILES WHERE FILE_ID = 687 > > I get the results in a snap > > However If I try > > DELETE FROM FILES WHERE FILE_NAME = "THISFILE.TXT" > > This takes about 5 minutes. I thought it might be an index > thing so I tried > > DELETE FROM FILES WHERE FILE_ID = 687 > > and it still took over 5 minutes. FILE_ID is the PRIMARY KEY > so I know it > is already indexed. I don't think a delete should take this > long. Please > help. Did you check the possibility of lock collisions on the table. You should have a look into system table lockstatistics. Kind regards, Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
