Why join on CHANGETABLE during the initialization? RRS feed

  • Question

  • We have recently had to remove the join with the CHANGETABLE from the initialization of some tables for our client SQLCE DB's due to performance issues, and I do not understand why it was even joining in the first place. 

    The queries where obtained from the generated sync adaptors and are now wrapped in stored procedures on the server. They closely match the examples here: http://msdn.microsoft.com/en-US/library/cc761496(v=SQL.90).aspx

    What effect would removing the join have? Is the join required for tables that are download only, rarely changed, or 99% of time only changed by the client? What about tables that are frequently updated by both the client and server?





    Friday, January 14, 2011 1:50 AM