locked
Downloading 7,00,000 records RRS feed

  • Question

  • I have SQL server as the source and SQL Express as the client database. I have around 7,00,000 records to be fetched newly from server to the client(SQL Express). My SQL Express hangs.

    Is there any optimization in Sync Framework when I fetch new records(not modiefied) ? Can anybody help me, please?

    Thanks and Regards,

    Swanand

     

     

    Wednesday, October 6, 2010 10:12 AM

All replies

  • is this just for initial synchronization? are you running on an n-tier setup?
    Wednesday, October 6, 2010 11:27 PM
  • how long are you letting it hang? I sync ~3 Million rows in about 45 min, the processor is chugging 100% of the time .... i would also ensure you are not attempting to sync these 7 Mil in one transaction, using ApplicationTransacionSize,
    Thursday, October 7, 2010 12:24 PM
  • Can you register provider event and check where the sync session hung?

    Thanks,


    Ann Tang
    Thursday, October 7, 2010 6:44 PM