Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

session queries?

Status
Not open for further replies.
lucidtech

lucidtech

IS-IT--Management
Jan 17, 2005
267
US
I have two queries that I use over and over again in my site when users are logged in. Is it better practice to set these queries as a session variable so I don't have to perform the query every time the user goes to a new page, or will it bog the system down if too many people are signed on?

 
Sort by date Sort by votes
If the query results don't change much, just cache the queries.

<cfquery name="" cachedwithin="whatever">


Hope This Helps!

ECAR
ECAR Technologies

"My work is a game, a very serious game." - M.C. Escher
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Ceilicat
  • Locked
  • Question
Query of Queries Union Not Totaling Across Fields
Replies
2
Views
149
OneTrickPony
OneTrickPony
lwfg
  • Locked
  • Question
session variable timeout problem
Replies
2
Views
123
lwfg
lwfg
emorobot
  • Locked
  • Question
Very odd session bug on my live server with session variables
Replies
0
Views
85
emorobot
emorobot
metaphiz
  • Locked
  • Question
Logout Doesn't Really End Session
Replies
1
Views
79
FALCONSEYE
FALCONSEYE
lucidtech
  • Locked
  • Question
session variables with mobile
Replies
11
Views
167
lucidtech
lucidtech

Part and Inventory Search

Sponsor

Back
Top