Форум керамистов

Художественная керамика - форум сайта "КерамикАрт.Ру"

Вы не зашли.

#1 2017-09-05 15:09:01

roberthans
Участник

Very slow - no idea why

Hi all;

This is something weird I ran across recently.

We had a report (Windward, not SSRS) that was pretty basic, 9 pages long, and it was taking over 1 minute to run. I ran it under a profiler and 92% of the time is in the ADO.NET connector (i.e. SQL Server was slow to respond). And then about 1 time out of 20, it would be the expected 2 seconds. Something weird was going on…

To cut to the chase, by changing the selects, I got it down to 2 seconds. I did this by crafting better selects. But the thing is, the amount of data was so small, it shouldn’t have made a difference.

I have all the details here.

My guess is that SQL Server is optimized for standard ways of pulling down selected data from large databases. And optimization is trade-offs where you build up caches, structures, etc. to then be able to handle 100,000 queries against a terabyte of data. And for our case, that was just a ton of unnecessary overhead. Or maybe we just hit some very weird combination of calls that it handles poorly.

Thank You!!!

I didn't find the right solution from the Internet.
References
http://www.dbforums.com/showthread.php? … o-idea-why
Global Trade Video

Неактивен

 

Board footer

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson

Реклама:

Rambler's Top100