Eric
Posts: 5743
Joined: 10/10/2003
From: Seattle, WA
Status: offline
|
I'm continuing to make progress on the pivot reports. Next up after is UI to control sorting and a combination view that compares current inventory to consumption and purchases so you can see trends.
REPORTING
(1) Alright, that feels a lot better! I just made the pivot reports about 8-10x faster when run against the whole database. Since I had switched to the incredibly cool and fancy new pivot reports about a month ago, I was seeing some very slow performance for these new reports when run against the entire database. Reports that should have taken 2-3 seconds would often take more like 20 which just stinks. Anyway, there was no immediately apparent fix. However, I finally cracked the riddle and figured out how to get SQL Server to be smart about these. The funny thing is that none of the queries changed one iota, but I did shuffle the way these are 'packaged and presented' to SQL Server. Anyway, it is happy again, and the reports are snappier than they ever were: generally immediate when run for one cellar and maybe 2-4 seconds when run against the entire database. (BTW, if anyone reading this is an expert on Microsoft SQL Server 2000, I would gladly share a glass of wine with you while chatting about the merits of schemabound objects, user-defined table functions and especially user-defined inline table functions (my savior)!
(2) I added new pivots for consumption data and migrated the existing consumption summary to use this new facility.
_____________________________
Cheers!
-Eric LeVine
|
Printable Version
v 2.4.23 release notes - 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread