Page 1 of 1
problem with sessions
Posted: Wed Nov 24, 2004 11:17 pm
by murthy
Hi,
I am displaying 15,000 records in a single page by using sessions.
at the time of loading it is taking too much time nearly 10 min.
At the time loading i am trying to navigating other links in my site.those pages are also not loading....
i am thinking problems with sessions....
I AM waiting for your reply
Thanks
Murthy
Posted: Thu Nov 25, 2004 3:35 am
by phpScott
are you storing all 15,0000 records in the session, if so you need to rethink you program as that is far to many for sessions to easily handle and IMHO an abuse of what sessions where designed for.
If you are storing all the records in the session then you need to just store the query, userId, something to reference that record set in the db. As well you will find it will be much faster to try and break that record set up into smaller chunks.
Posted: Thu Nov 25, 2004 3:41 am
by murthy
thanks .... for your response
I am storing only username and password in sessions ..... by using this i am fetching all records from the database.I am displaying all records in one page only.
Murthy
Posted: Thu Nov 25, 2004 3:48 am
by phpScott
whew!!!! i was scared there for a second. Unless you have a very strong need to return all the results on one page I would suggest using a form or [devnet]pagination[/devnet] or check out kettle_drums class at
http://www.redvodkajelly.com/index.php?v=code/3 as it is quite good as well.
15000 records is a lot and that is why you page is slow to load.