|
|
Posted by Moot on 10/18/06 20:35
monomaniac21 wrote:
> hi all
>
> i have a script that retrieves rows from a single table, rows are
> related to eachother and are retrieved by doing a series of while loops
> within while loops. bcos each row contains a text field they are fairly
> large. the net result is that when 60 or so results are reitreved the
> page size is 400kb! which takes too long to load. is there a way of
> shorterning this? freeing up the memory say, bcos what is actually
> displayed is not that much, its just the use of multiple loops (about
> 10) that does it i think
If the page size delivered to the browser is 400kb, then it's 400kb's
worth of data. You can't change that by freeing up memory in PHP.
If the page is getting too large, then consider using pagination to
break up all that data into smaller sets across multiple pages. For
instance, limit each page to only show 100 records and provide
Previous/Next links to navigate across all the results.
Moot
Navigation:
[Reply to this message]
|