Array or ask again ?

[AngryT]

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

[DeadEyes]

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.

[randem]

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.