Slow uploading of TXT or CSV file

Once you've installed phpList... ask questions here!
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

Slow uploading of TXT or CSV file

Postby trempesthumphries » 4:12am, Wed 27 Aug, 2014

I'm uploading a plain text file containing 150,000 email addresses at one email address per line.

The file is 1.3Mb and the upload takes 5 hours to complete on a server located in the LAN.

Any advice on what needs to be tweaked?
trempesthumphries
phpList newbie
 
Posts: 4
Joined: 4:08am, Wed 27 Aug, 2014

Re: Slow uploading of TXT or CSV file

Postby danwaterloo » 7:06pm, Sun 31 Aug, 2014

you might want to see what the load is on the server. If it's high, then the php scripts will execute slower.

Since the system is inserting into the database, you should also check the load and config settings on your mysql database. Make sure most work is done in RAM.
danwaterloo
PL Master
 
Posts: 276
Joined: 3:51am, Wed 30 Oct, 2013
Location: http://www.phplistsupport.com

Re: Slow uploading of TXT or CSV file

Postby trempesthumphries » 9:18am, Mon 15 Sep, 2014

Thanks. I found that my MySQL engine was using INNODB. I changed this to ISAM and tweaked some query_cache_size and query_cache_limit config and achieved very good upload speeds.

Thank you.
trempesthumphries
phpList newbie
 
Posts: 4
Joined: 4:08am, Wed 27 Aug, 2014


Return to Questions and Problems after Installing

Who is online

Users browsing this forum: No registered users and 2 guests