[PHP-DB] Re: Delete from mysql table is there a way to....

2002-04-15 Thread phplists
Maybe if you ran the delete query, then the optimize table query immed after, it wouldn't take such a long time.. I would imagine if you had quite large tables though, it could still take some time.. And if users are connecting over the internet, you don't want too may delays.. If the user doesn'

[PHP-DB] Re: Delete from mysql table is there a way to....

2002-04-15 Thread phplists
I'm not sure how to change DELETE statements in this fashion, but is there a way maybe to run an OPTIMIZE TABLE query every so often in your PHP script.. I don't imagine you'd want it running too often since it locks the table you run it on, but maybe on the reload of $PHP_SELF or something.. It c