Load temp table for ASP pages

[MacroAlan]

The data on the SQL Server is over 70,000 rows. The pages refresh very slowly when I am making SUMing and GROUPing in the queries. Even after that, I frequently are left with 100s of rows.

I want to load the Temp table when the page is called and use it until the user goes elsewhere. My form has 4 dropdowns that are created from the data and builds 2 charts and 2 GridViews.

I don't want the user to be making a trip back to the SQL Server every few seconds.

Found some code to make a TEMP table but it loads from data keyed on screen. I already know how to make connection string. I need help with opening a query and filling the table.

[highlight #F57900]Anybody got some sample code??[/highlight]


Alan

 

[ElEye]

Have you tried CTE (Common Table Expression?) If that's not clear you may want to post your inquiry to the SQL Server Programming forum. Here's a link I found:

https://www.simple-talk.com/sql/t-sql-programming/sql-server-cte-basics/

Dave
[

http://flashspot.com

]

 

[MacroAlan]

I was thinking of storing the temp file in virtual space on the users machine. Queries would be lightning fast.

May need to get space allocated to my app on the SQL Server?




Alan

 

[ggriffit]

have you tried SQL Profiler to see if there is an issue or tuning opportunity with your SQL, could be Indexes etc, or underpowered SQL Server etc, that is likely to increase performance more than shipping data to a client machine - which will take up bandwith etc and may be difficult to store in some cases e.g. browser based etc.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/