Comments
Sort by recent activity
Hi Glen,
No worries - glad it's working again in any case! Let me know if you do hit the problem in the future.
Cheers,
Robert / comments
Hi Glen,
No worries - glad it's working again in any case! Let me know if you do hit the problem in the future.
Cheers,
Robert
Sorry... another couple of quick questions!
- Could you tell me the version number if you go to Help -> About?
- How much physical RAM do you have in the machine you're running Data Compare on?
Many thanks,
Robert / comments
Sorry... another couple of quick questions!
- Could you tell me the version number if you go to Help -> About?
- How much physical RAM do you have in the machine you're running Data Compare on?
Man...
Hi,
I wonder if I could grab some more details - are you comparing two "live" databases, or are you comparing against a backup? Roughly what sort of scale are your databases - both in terms of the number of tables, and the amount of data in them?
In general we should be able to scale to arbitrarily large databases, but there's a couple of particularly nasty cases where that won't work (e.g. having individual rows with huge amounts of data in them).
Thanks,
Robert / comments
Hi,
I wonder if I could grab some more details - are you comparing two "live" databases, or are you comparing against a backup? Roughly what sort of scale are your databases - both in terms of the ...
Hi,
You say "when running in the normal debugger" - that's something worth watching out for. Throwing exceptions whilst the VS debugger is attached has a serious performance penalty.
I changed your code slightly to use Environment.TickCount rather than DateTime.Now, which gave me millisecond timing nice and easily.
Running inside the debugger, I got results of 0ms for the first case, and 3120ms for the second. Outside the debugger, that second reading went down to 60ms!
Running inside ANTS Profiler, I got results of 100ms and 350ms reported by ANTS for the two tests, and 47ms and 359ms reported on the console. Admittedly it's not perfect, but it is in the right order of magnitude. This isn't too surprising, given the still small amount of work actually being done in the loop.
Hope that helps,
Robert / comments
Hi,
You say "when running in the normal debugger" - that's something worth watching out for. Throwing exceptions whilst the VS debugger is attached has a serious performance penalty.
I changed your...
Hi,
It's not whether it's a release or debug build that makes the difference - it's that you're running it inside a debugger (perfectly possible on a release build, you just get less useful information :-p).
Try running it completely outside of Visual Studio, or else use the Debug -> "Start Without Debugging" option in VS.
I think you'll find it's not ANTS interfering, it's the VS debugger :-). (This only applies to exceptions - in code flow that isn't heavy on exceptions, the VS debugger has a much lower impact)
Robert / comments
Hi,
It's not whether it's a release or debug build that makes the difference - it's that you're running it inside a debugger (perfectly possible on a release build, you just get less useful informa...
Hi,
There seems to be a common factor of an upgrade from 5 to 6 to 6.1 in both of those. We've tested this internally but haven't managed to reproduce it here yet.
If anyone does hit this problem, any details of the error given would be appreciated so we can try and narrow it down.
Many thanks,
Robert / comments
Hi,
There seems to be a common factor of an upgrade from 5 to 6 to 6.1 in both of those. We've tested this internally but haven't managed to reproduce it here yet.
If anyone does hit this problem, ...
Hi,
You need to select "winword.exe" as the application you want to profile, rather than your Add-in DLL. I've not personally tried it with Word, but Outlook 2007 add-ins certainly work using this method.
Hope that helps,
Robert / comments
Hi,
You need to select "winword.exe" as the application you want to profile, rather than your Add-in DLL. I've not personally tried it with Word, but Outlook 2007 add-ins certainly work using this ...
Hi,
The trick here is to profile the office application you're actually hosting your addin in, so Word / Excel / Outlook. I'm assuming you've got the addin loading on start up already, so you shouldn't need to do any further configuration.
When you try and start profiling, ANTS Profiler may warn you that you haven't selected a .NET executable, but accept this warning and carry on anyway. As the application starts up, watch the status bar in ANTS Profiler - it should change from "Waiting for connection..." to "Profiling performance of...".
I've just done a really quick test here in Office 2007, and it all seems to work nicely.
Hope that helps,
Robert / comments
Hi,
The trick here is to profile the office application you're actually hosting your addin in, so Word / Excel / Outlook. I'm assuming you've got the addin loading on start up already, so you shoul...
Hi,
Thanks for reporting that - I've just recreated it here, and I see the same result as you.
The individual object pages correctly show [dbo].[Module1.Table1], so it just seems to be the uses / used by statements that are wrong.
I've logged it in our bug tracking system (issue SDOC-780), so hopefully it should get fixed for the next release of SQL Doc.
Many thanks,
Robert / comments
Hi,
Thanks for reporting that - I've just recreated it here, and I see the same result as you.
The individual object pages correctly show [dbo].[Module1.Table1], so it just seems to be the uses / u...
Hi,
Just to let you know, 6.1 is now out. You can get this by going to Check for Updates on the Help menu.
Robert / comments
Hi,
Just to let you know, 6.1 is now out. You can get this by going to Check for Updates on the Help menu.
Robert