Page 1 of 1
Multi-threaded db Compare
Posted: Fri 18 Jul 2014 00:55
by ribbles
A DB compare operation takes an hour on my machine. I see that CPU and IO are under-utilized. I am running SQL server and Data Compare locally, connecting via shared memory. I am running with i7 4 core and SSD for the database.
Would the application benefit from some multi-threading?
Re: Multi-threaded db Compare
Posted: Fri 18 Jul 2014 08:43
by alexa
The tool works in multi-threading as it is.
We recommend you to check the server's performance and the tables' content. We suppose the weak place may lie in data transmission.
Re: Multi-threaded db Compare
Posted: Mon 28 Jul 2014 05:21
by ribbles
Thanks for getting back to me.
In what way is it multi-threaded?
Re: Multi-threaded db Compare
Posted: Mon 28 Jul 2014 09:36
by alexa
Retrieving, comparing and caching data are multi-threaded.
Re: Multi-threaded db Compare
Posted: Tue 29 Jul 2014 05:34
by ribbles
That's not what Microsoft Process Explorer shows:

Re: Multi-threaded db Compare
Posted: Mon 04 Aug 2014 13:27
by alexa
We will reconsider the current behavior in future product versions.