INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Load temp table for ASP pages

Load temp table for ASP pages

(OP)
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.

Anybody got some sample code??


Alan
smurf

RE: Load temp table for ASP pages

(OP)
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
smurf

RE: Load temp table for ASP pages

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/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close