Performance help needed

vba Kuwait
  • 15 years ago

    Hi all,
    I have 2 SQL database with almost 7 million record with the same filed in both, I am looking for in select or if statement which can do for me in less time.
    1- Compare both sqldb & list me statistic for number of different in each filed. And list for me the 2 filed from each sqldb are the different.
    2- My target to filter these 2 sqldb and find where and how many record are mismatch & and list them for next step to correct them. I Like to have the different in output1.txt file.

    Some coding take 4 hours and I am sure there must be faster way.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Beware of bugs in the above code; I have only proved it correct, not tried it.” - Donald Knuth