Store product data in session variable or access db every time?

Posted by JakeTheSnake on Server Fault See other posts from Server Fault or by JakeTheSnake
Published on 2011-01-07T16:47:11Z Indexed on 2011/01/07 16:56 UTC
Read the original article Hit count: 137

Filed under:

database-performance

|

sessions

|

variables

I have my database storing lots of information about products (year, name, release_date, volume, etc. etc.). I currently load all of the products once and store them in a session variable - right now there's only 8 products but the list will grow as time progresses. The reason why I did this was to (perhaps foolishly) save HDD reads every time the products page was accessed. Am I shooting myself in the foot by storing this information in the session?

© Server Fault or respective owner

Related posts about database-performance

A Perspective on Database Performance Tuning

as seen on SQL Server Central - Search for 'SQL Server Central'
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer… >>> More
A Perspective on Database Performance Tuning

as seen on Internet.com - Search for 'Internet.com'
Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply for any given situation. Julian Stuhler looks at database performance tuning, and why it remains one of the most important topics for any DBA, developer… >>> More
Will Check Constraints Improve Database Performance?

as seen on SQL Server Performance - Search for 'SQL Server Performance'
[Read Full Article] >>> More
Database Performance Across 3 NetApp FAS2050

as seen on Server Fault - Search for 'Server Fault'
I recently inherited a SQL Server 2005 box that has LUNs mounted on it from three different NetApp FAS2050 filers. The reason there are three is because the first two filers are out of space and our databases continually need more of it. What kind of performance impact (if any) does this setup have… >>> More
Database performance benchmark

as seen on Stack Overflow - Search for 'Stack Overflow'
Any good articles out there comparing Oracle vs SQL Server vs MySql in terms of performance? I'd like to know things like: INSERT performance SELECT performance Scalability under heavy load Based on some real examples in order to gain a better understanding about the different RDBMS. >>> More

Related posts about sessions

SQLAuthority News – Speaking Sessions at TechEd India – 3 Sessions – 1 Panel Discussion

as seen on SQL Authority - Search for 'SQL Authority'
Microsoft Tech-Ed India 2010 is considered as the major Technology event of the year for various IT professionals and developers. This event will feature a comprehensive forum in order to learn, connect, explore, and evolve the current technologies we have today. I would recommend this event to… >>> More
SQLAuthority News Speaking Sessions at TechEd India 3 Sessions 1 Panel Discussion

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Microsoft Tech-Ed India 2010 is considered as the major Technology event of the year for various IT professionals and developers. This event will feature a comprehensive forum in order to learn, connect, explore, and evolve the current technologies we have today. I would recommend this event to you… >>> More
CherryPy sessions for same domain, different port

as seen on Stack Overflow - Search for 'Stack Overflow'
Consider the script below. It will launch two subprocesses, each one a CherryPy app (hit Ctrl+C or whatever the KeyboardInterrupt combo is on your system to end them both). If you run it with CP 3.0 (taking care to change the 3.0/3.1 specific lines in "StartServer"), then visit: http://localhost:15002/… >>> More
Want to go to DevConnections for Free? Speak at DotNetNuke Connections

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
So every year in November (for the past 3 years at least!) DotNetNuke has been part of the DevConnections conference in Las Vegas, Nevada. This year (2010) will be no different as DotNetNuke Connections is back ( This year’s conference is scheduled for 11/1-11/4/2010 ) and guess what? I… >>> More
The Deadline Cometh

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Only Two More Days to Suggest a Session. We've received 2,906 votes for presentations since the launch of the Suggest a Session program. Have you voted? Have you suggested a presentation for Oracle OpenWorld 2010 or Oracle Develop 2010? If "yes," you've done well. If "no," you still have a chance… >>> More