disable duplicate post check in wp-all-import wordpress plugin

Question

I am using the wp all import wordpress plugin to import posts to my wordpress blog from a csv file. The file has over 10000 posts, the problem is the plugin posting gets slower as the database size increases or if it posts about 1000 posts the number of posts published decreases to 1/4th of the rate when the process began.

Is it possible to prevent duplicate check by the plugin?

Or can I limit the data read from the wordpress database to 100 posts instead of reading the 1000 posts?

Answer 1

it seems your server is struggling as this operation is resource intensive.Sending all these SQL queries in your DB will surely slow things down in your server. You could try some things and see if it helps.

• Try to split the script into chunks and parse a small number of posts at the time (ex. 1000).
• Disable do_action
• Try to increase the execution time of php scripts (this is unlikely to help, but if nothing helps give it a try).
• Import an sql file backup directly into your database using a DBMS (Mysql Workbench, PgAdmin etc...), and import the xml file that maps the db with the posts. More info:

About WP all import here

About Wordpress backups here