Dan wrote:
I need to retrieve a huge amount of data form a database and do so many
times. To eliminate the overhead of connecting to the database and
pulling down all that info over and over, I'm trying to pull it down
only once and stick it into a session. The problem is I get the first
It's already in an array format. I don't remember off the top of my head but
there's some function like resultsarray which turns the resutls into an array.
I'm already storing the array in the session.
John A DAVIS [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
stick in in an
Dan wrote:
After thinking about this a while I also thought of making my own
cache. The problem with that is would it be any faster or have any
less strain on the server than having multiple requests/connections to
the database?
A lot depends on the amount of data and the overall load on the
I need to retrieve a huge amount of data form a database and do so many
times. To eliminate the overhead of connecting to the database and pulling
down all that info over and over, I'm trying to pull it down only once and
stick it into a session. The problem is I get the first few results and
Dan wrote:
I need to retrieve a huge amount of data form a database and do so
many times. To eliminate the overhead of connecting to the database
and pulling down all that info over and over, I'm trying to pull it
down only once and stick it into a session. The problem is I get the
first
After thinking about this a while I also thought of making my own cache.
The problem with that is would it be any faster or have any less strain on
the server than having multiple requests/connections to the database?
- Dan
Per Jessen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Does the data change often? If not you could just enable query cache and
cache connection threads and you'd probably be fine.
Dan wrote:
After thinking about this a while I also thought of making my own
cache. The problem with that is would it be any faster or have any
less strain on the
The data doesn't change often but the querys do. Thats why I was
origionally thinking of just storing the entire result in a session and just
use the part of the session I needed. So caching wouldn't really work.
That was something intresting though that I didn't know earlier thanks!
- Dan
stick in in an array in a session
"Dan" [EMAIL PROTECTED] 10/3/2007 2:21 PM
I need to retrieve a huge amount of data form a database and do so many times. To eliminate the overhead of connecting to the database and pulling down all that info over and over, I'm trying to pull it down only
9 matches
Mail list logo