Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Synchronization Slow To Delete Rows

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Synchronization Slow To Delete Rows

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • October 9, 2006 at 6:35 pm #9954
      Kyle V
      Member

      Hi,

      I have 2 identical tables on different servers. One is local to the machine, and the other is on a website.

      The table has around 200,000 rows. lets say I delete 6000 rows from the local table, and save it. It immediately deletes all the rows. Then i go and run a database synchronization so that it will delete the same 6000 rows from the website's table. It takes like 45 minutes to delete the same rows from the website (when nothing was inserted or updated). why is this?

      Any help would be great.. thanks a lot.

    • October 9, 2006 at 9:12 pm #22759
      peterlaursen
      Participant

      The reason is that checksums will have to be calculated for every 200.000 rows uing every columns if you do not use the and optimization parameters. You have noticed that first INSERTS, next UPDATES and finally DELETES are done. To check for UPDATES checksums are needed.


      @Manoj      : why will updates have to wait for checksum to be built? Does DELETES use the checksums?

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.