Session Variable question

[Shazbot!]

I have a page that runs a query that totals the sums of totals for over 5000 people. The customer can then download this information.

The process takes about 2 minutes and then the results are placed in a Session Variable. This is so the user can review the information without having to run the query again.

 

The data is very large and I have noticed that it is slowing page navigation through the Intranet site. Is there another place where I can temporarily store this large data where it won't affect page surfing?

[per1os]

Buy more memory and allocate more memory?

[ViN86]

I have a page that runs a query that totals the sums of totals for over 5000 people. The customer can then download this information.

The process takes about 2 minutes and then the results are placed in a Session Variable. This is so the user can review the information without having to run the query again.

 

The data is very large and I have noticed that it is slowing page navigation through the Intranet site. Is there another place where I can temporarily store this large data where it won't affect page surfing?

why dont you store the results into a text file on the server and log the data included in the file.  then when they want the data, it reads the file.  that should speed up the process.

[Shazbot!]

Thanks ViN86,

however, they will not allow PHP to have write permissions.

 

Thanks frost110,

Not my server and I have no access to to change any settings.

[per1os]

Thanks ViN86,

however, they will not allow PHP to have write permissions.

 

Thanks frost110,

Not my server and I have no access to to change any settings.

 

Good luck. I bet you are SOL (Shit out of Luck)