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]
