Re: Need For SPEED
| From: | Phil Driscoll | Date: | Thu, 21 Aug 2003 16:55:13 +0000 |
| Subject: | Re: Need For SPEED | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30025@lists.php.net to get a copy of this message | ||
I'm not familiar with PHPList but...
You might be able to get a significant speed increase by creating indexes in
MySQL on some more of the fields in the table. For example, if the list code
checks for duplicate email addresses, and the email address field is not
indexed, then creating an index on that field will speed things up lots -
especially as the table becomes big.
--
Phil Driscoll