March 20, 2006 at 2:40 am
Hi, I have a web app., the data is in 4 tables in sql server, the total rows in the 4 tables is about 600,000, each row contains 3 fields.
My question is do I keep all the tables in memory from the start of the application and build the dataset for each user (an average of 100 rows)from the tables in memory or do I access the tables in sql server for each user?
Pointers to articals tutorials appriciated.
March 21, 2006 at 12:01 pm
Creating large datasets gives you great performance as long as you only have one user at a time.
Try to estimate the maximum number of concurrent users, and the size of the datasets you want to create. Multiply these two numbers together and compare to the memory normally available on the web server.
If you're thinking of some kind of caching scheme where one large dataset is kept on the web server, the question is still whether or not the web server can afford the memory for one copy of the dataset. You don't say what the three columns are, but if they are small it sounds like it will require a few megabytes. Your web server should be able to handle that unless it is really loaded already.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply