Title: table import – interruption?
Last modified: September 1, 2021

---

# table import – interruption?

 *  [edhillis](https://wordpress.org/support/users/edhillis/)
 * (@edhillis)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/table-import-interruption/)
 * I’m working with a table of about 5000 rows. I have some updates to make, and
   have used the reload (and truncate) method to make these previously before the
   site was live. Now that the site is live and there are several users at all times,
   my question is: does the reload (truncating) process interrupt the use of the
   site for the current users? Basically all actions on the site are querying and
   reading from the table in question – but not inserting. Thank you for your help!

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

 *  [michael3740](https://wordpress.org/support/users/michael3740/)
 * (@michael3740)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/table-import-interruption/#post-14829443)
 * I do something similar. As soon as a table is truncated it becomes empty, and
   stays empty until the update process is completed.
    Any queries will return empty.
   I have almost 8000 rows and import an SQL dump from my source table which takes
   30 – 45 seconds.
 * Hope that helps.
 * Michael
 *  Thread Starter [edhillis](https://wordpress.org/support/users/edhillis/)
 * (@edhillis)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/table-import-interruption/#post-14829461)
 * Thanks for your reply! I’m importing a CSV and it actually takes a few minutes
   to complete. It’s interesting: I experimented doing the import on a dev site,
   and used the site in several ways to test. I experienced no interruption at all
   in querying the table. I don’t have the knowledge to understand what is happening
   here, or whether it would be unwise to generalize from my experience and assume
   no viewer would have to wait.
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/table-import-interruption/#post-14830417)
 * Hi,
 * In the time between the truncate and import, users will have access to an incomplete
   dataset. Would a temporarily message “database being update, we’re back in a 
   few minutes…” be acceptable for now?
 * >>> It’s interesting: I experimented doing the import on a dev site, and used
   the site in several ways to test. I experienced no interruption at all in querying
   the table.
 * Does your dev site have a cache plugin? Or is the data cached somewhere else?
 * I’m working on two premium future solutions:
    (1) Using savepoints (does not 
   work with MyIsam) (2) Using updates (only works if your table has a primary|unique
   key)
 * Best regards,
    Peter
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 8 months ago](https://wordpress.org/support/topic/table-import-interruption/#post-14877189)
 * Any updates on this topic?

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

The topic ‘table import – interruption?’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 4 replies
 * 3 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [4 years, 8 months ago](https://wordpress.org/support/topic/table-import-interruption/#post-14877189)
 * Status: not resolved