Title: CSV Import Speed
Last modified: April 7, 2017

---

# CSV Import Speed

 *  Resolved [jimario](https://wordpress.org/support/users/jimario/)
 * (@jimario)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/csv-import-speed/)
 * I’ve updated the plugin to the latest version. I’m trying to import a csv file.
   The file size is only 6mb yet I’m averaging 1% every 2 minutes. Is this typical
   of importing csv files to the plugin?
 * I ran a speedtest on my internet connection and I’m getting 33mbps or 4MB/sec.
   All of my header names match the sample csv as does the grouping of the data.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/csv-import-speed/#post-9008279)
 * Hi [@jimario](https://wordpress.org/support/users/jimario/),
 * Sorry that you ran into issues here!
 * The CSV import speed is not strictly a network issue. Because we’re a custom 
   post type, each record in the CSV must have the following done:
    – Create a BD
   listing (custom post type, essentially creating a record in WP) – Confirm the
   category exists and associate it if it does. Create it if it does not – Process
   any images you have associated with it and upload them through the media API
 * The WP API is quite frankly, not so fast with these operations. It would be faster
   if we could just jam data into custom tables but because WP does processing on
   things, their API calls are a bit more pokey than we’d like. But we’re stuck 
   with them, unfortunately.
 * Other factors that can slow you down:
    – Shared hosting – Slow database query
   connection – Lack of CPU resources
 * Does that make more sense?
 *  Thread Starter [jimario](https://wordpress.org/support/users/jimario/)
 * (@jimario)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/csv-import-speed/#post-9008382)
 * Thank you for responding to my question. Yes, what you say does make sense. However,
   I did get an error and by the time I got to 12%. The error message said:
 * _A fatal error occurred during the import. If connection wasn’t lost during the
   import, please make sure that you have enough free disk space and memory available
   to PHP. Check your error logs for details. _
 * It looks like I was able to get 2,028 records imported out of 21,523. This was
   one of my smallest csv files. The average size of my csv files is 60-90mb. Typically,
   how fast does the import process take even if database query connection is quick&
   cpu resources are adequate?
 *  Plugin Author [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * (@businessdirectoryplugin)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/csv-import-speed/#post-9009995)
 * Hi [@jimario](https://wordpress.org/support/users/jimario/),
 * If your CSV files are 60-90MB, part of the issue is simply the upload aspect 
   of it–that’s a lot of data to pull up and process in one chunk with PHP threads.
 * Try breaking up the import into smaller files–maybe no more than 10MB per file.
   That may help make this go more smoothly.
 * There’s no blanket answer on CPU there–there are other constraints that typically
   factor in that are more important (RAM being first, and by RAM I mean the RAM
   allocated to a PHP thread for processing. It’s not the same as the RAM you have
   for your web server instance…this is a setting in php.ini and usually controlled
   by the host). The database query timeout is another and that is the one that 
   usually gets a lot of people, the error you’re seeing could be from that.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘CSV Import Speed’ is closed to new replies.

 * ![](https://ps.w.org/business-directory-plugin/assets/icon-256x256.png?rev=2901888)
 * [Business Directory Plugin - Easy Listing Directories for WordPress](https://wordpress.org/plugins/business-directory-plugin/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/business-directory-plugin/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/business-directory-plugin/)
 * [Active Topics](https://wordpress.org/support/plugin/business-directory-plugin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/business-directory-plugin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/business-directory-plugin/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [speed](https://wordpress.org/support/topic-tag/speed/)
 * [very slow](https://wordpress.org/support/topic-tag/very-slow/)

 * 3 replies
 * 2 participants
 * Last reply from: [Business Directory Plugin](https://wordpress.org/support/users/businessdirectoryplugin/)
 * Last activity: [9 years, 1 month ago](https://wordpress.org/support/topic/csv-import-speed/#post-9009995)
 * Status: resolved