Hello, 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. Thanks, -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
