Diagnosing WP All Import Performance Issues with Scalability Pro

Scalability Pro does a lot of work to optimise your WP All Import jobs, but sometimes an import can still be slow. The optional Scalability Pro Query Monitor Add-on (spro-addon-query-monitor) makes one WP All Import batch visible in the browser, allowing Query Monitor or another profiler to capture it. The diagnostic add-on is deliberately separate from Scalability Pro because it evaluates WP All Import Pro’s own batch-handler file and should only be installed temporarily while investigating a specific import.

When running WP All Import jobs, identifying performance bottlenecks can be challenging because the import process typically runs through AJAX or CLI, making it difficult to monitor what’s happening behind the scenes. Scalability Pro provides a solution that allows you to analyze the performance of your imports.

WP All Import is a powerful tool, but when imports are slow or causing server issues, troubleshooting can be difficult because import processing happens in the background via AJAX, database queries are not visible during normal operation, performance bottlenecks are hard to identify, and server timeouts can occur without clear indication of the cause.

This guide assumes you already have a WP All Import job set up and ready to run. You’ll need the Import ID of your job, which you can find in the URL when editing your import or in the imports list.

Step 1: Trigger the Import Using the Direct URL

Use the following URL format to trigger your import:

https://your-site.com/wp-load.php?import_key=YOUR_IMPORT_PASSWORD&import_id=YOUR_IMPORT_ID&action=trigger

Replace YOUR_IMPORT_PASSWORD with your import password (found in WP All Import settings) and replace YOUR_IMPORT_ID with the ID of your import.

Step 2: Install the temporary diagnostic add-on

Ask Super Speedy Plugins support for spro-addon-query-monitor, install it as a separate plugin and activate it alongside Scalability Pro, WP All Import Pro and Query Monitor. Do not leave the add-on active as an everyday optimisation. It exists only to expose one diagnostic batch.

Step 3: Run a Batch with query monitoring

To diagnose performance issues during your import:

1. Install Query Monitor plugin or Code Profiler Pro before proceeding

1. Modify the import URL by adding the spro_show_import_queries=yes parameter:https://your-site.com/wp-load.php?import_key=YOUR_IMPORT_PASSWORD&import_id=YOUR_IMPORT_ID&action=processing&spro_show_import_queries=yes

1. Load this URL in your browser. This will:

• Run a single batch of the import in the browser

• Display the WP All Import output directly in the page

• Allow Query Monitor or Code Profiler Pro to analyze the execution

Step 4: Analyse the results

With Query Monitor or Code Profiler Pro, you can now analyze:

1. All SQL queries executed during the import batch

1. Query execution times

1. Memory usage

1. Function calls

1. Hooks and filters that might be affecting performance

This information helps you identify:

• Slow or inefficient queries

• Parts of the import process taking the most time

• How WP All Import is processing your data

• Specific performance bottlenecks

Troubleshooting

If you analyse your import and find issues you cannot optimise, please contact us through our Discord support server and provide screenshots and your own judgement of your analysis and we’ll assist. Frequently, we can improve Scalability Pro to optimise your imports even further with more feedback provided by our customers.

Summary

Scalability Pro handles the everyday import optimisations. When a specific import still needs investigation, temporarily install spro-addon-query-monitor and add spro_show_import_queries=yes to one processing request. Remove the diagnostic add-on again when the capture is complete.

Further reading

Related products

Scalability ProSpeed up your whole site – big catalogues, big databases, no re-architecture