How many rows are in the table? Is the "id" column indexed? It looks like it's scanning through each row to find a match. How long does it take to delete just the one row? If it's 2 seconds, then that delete is acting the same way. If you have a very small table, then it sounds like the database is swapping out to disk for each delete thus increasing your response time. You need to look at how much cache is available and the amount of memory on your server. -----Original Message----- From: Uli <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Friday, July 27, 2001 10:28 AM Subject: [PHP-DB] Problems with update und delete's >Hallo! > >Maybe you can help me with my problems. > >I have a html form that deletes (or updates) over a php-script datas from my >database like "delete from table_name where id=xy" > >and it works correctly. > >But when I have about 100 entries in my database then it takes about 50 sec. >to delete an entry. > >Do you know what it can be???? > >Please send replies to this newsgroup or to [EMAIL PROTECTED] > >Thanx a lot. > >Uli > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
