, August 21, 2003 7:26 PM
Subject: Re: [PHP-DB] Need For SPEED
Thanks. We're using the import function provided in PHPList. Looked at a
more direct method, but we need to properly initialize each data record in
the database.
Sorry about the cross-posting. Not sure which list can help.
Creigh
Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution, PHPList, to create
an e-mailing list for our 5.6 million book club members. Unfortunately,
the import speed for importing records (at record number 150,000 the rate
is about 2,000 records per hour). We're running on the following:
P4
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
-
From: Creigh Shank [EMAIL PROTECTED]
To: MySQL Users [EMAIL PROTECTED]; PHP-db List
[EMAIL PROTECTED]; PHPList Users [EMAIL PROTECTED];
Michiel Dethmers [EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 6:58 PM
Subject: [PHP-DB] Need For SPEED
Using an Apache/PHP/MySQL/Linux (Redhat 8.0
Creigh == Creigh Shank [EMAIL PROTECTED] writes:
Creigh Using an Apache/PHP/MySQL/Linux (Redhat 8.0) solution,
Creigh PHPList, to create an e-mailing list for our 5.6 million book
Creigh club members. Unfortunately, the import speed for importing
Creigh records (at record number 150,000 the