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)

  • 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

    (@edhillis)

    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

    (@peterschulznl)

    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

    (@peterschulznl)

    Any updates on this topic?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘table import – interruption?’ is closed to new replies.