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

Slow Datasync When Using Where

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Slow Datasync When Using Where

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • July 22, 2009 at 12:49 pm #11595
      terbonium
      Member

      Running a sync between two tables with minimal differences takes just 61 seconds. If I add a WHERE clause to reduce the number of rows compared the time jumps to 431 seconds. ( if I use an old copy v5 copy of sja the sync time is just 30 seconds)

      Table SrcRows TgtRows Inserted Updated Deleted

      ========================= ======= ======= ======== ======= =======

      `transaction` 353324 353322 2 3 0

      Total time taken – 61 sec(s)

      SQLyog Job Agent Version 8.12 Copyright© Webyog Softworks Pvt. Ltd. All Rights Reserved.

      ADDED “TRANSACTIONID >= 10336820“

      Sync started at Wed Jul 22 08:40:58 2009

      Table SrcRows TgtRows Inserted Updated Deleted

      ========================= ======= ======= ======== ======= =======

      `transaction` 353324 353324 0 0 0

      Total time taken – 431 sec(s)

    • July 22, 2009 at 1:46 pm #29340
      Mahesh
      Member

      1) Please zip and attach source and target table with sample data where this issue is reproducible along with JOB file?

      OR

      2) Is it possible to have temporary access to the source and target Database?

      You can create a ticket from here for privacy

      http://www.webyog.com/support/ttx.cgi

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