Printable View
Hi!
What is better to do:
I read some data of a SQL Server at the beginnig of my website.
Later I need the same data again. Is it better to read the data at first time in
an array and use the data of the array or should I ask my SQL Server again?
What are you doing in such a situation ?
More background information:
Webserver is a different server as the SQL Server.
I'm programming in C#.net
Thanks for your information!
Angryt
It would depend how much data your talking about and how often you need it.
Your options probably break down like this:
Application Variables.
Small amount of data that is the same for everyone
Session Variables.
Small amount of data that is different for everyone
Cookies.
Small amount of data,not-secure or trusted. cookies may not be enabled.
Re-Query DB.
Hitting the DB is what these apps do so while trying to reduce round trips is a good thing there is no point in going overboard.
I am more familiar with Classic ASP maybe .Net has some extra options.
AngryT,
This is not an Application Deployment question... You are in the wrong forum. Your question woluld have a better chance of being answered in the proper location.