Re: Problems with update und delete's

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 <uli1976@gmx.at> To: php-db@lists.php.net <php-db@lists.php.net> 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 uli1976@gmx.at > >Thanx a lot. > >Uli > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net >For additional commands, e-mail: php-db-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net >