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:
Do really want to delete this entry
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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
000a01c116a9$cd867630$[EMAIL PROTECTED]">news:000a01c116a9$cd867630$[EMAIL PROTECTED]...
> 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]
