Re: Problems with update und delete's

Its a mySQL DB at a providers Server, so I think the memory and the cache schould be okay. Mybe this helps: The HTML File look like this: <HTML> <BODY> <FORM action="admin_index.php3?id=2" method="post"> <center> Do really want to delete this entry <br> <br> <input type="Submit" name="btndeleteYES" value="Yes"> <input type="Submit" name="btndeleteNO" value="No"> </center> </FORM> </BODY> </HTML> and the function in the admin_index.php3 looks like this function delete_entry($svid) { .... $connectionID = FncOpenDatabase (); //this function works $svSQL = "delete from $cfgTabContent where id=$svid"; //heres the string $result = mysql_query( $svSQL, $connectionID); if ($result){return "1";} else {return "0";} } and it works "fast", about 2 secs, when there are about 30 entries in the table, but it takes longer (about 50secs) when there are about 100 entries in the table. the id is indexed..... maybe you have any ideas?? "Peter J. Krawetzky" <krawetzky1@earthlink.net> schrieb im Newsbeitrag news:000a01c116a9$cd867630$91131eac@W559878.hartford.aetna.com... > 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 > > >