I'm working with php and mysql. I have to do the following:
In page1 : Retrieving record 1 from mysql;
In page2 : Retrieving records 1,2 from mysql;
In page3 : Retrieving records 1,2,3 from mysql;
In page4 : Retrieving records 1,2,3,4 from mysql; .... so on
Each of these records are about 5KB of code.
If I store the index in session variable then I have to retrieve the same set of records again and again. This may not be efficient. Is it advisable to use session variables for storing such large data? How do I store the records that are so far retrieved in the client side and make it efficient?
Thanks in advance,
Shwathi