PHP Smarty Templates - Re: [SMARTY] direct way to handle mysql result sets (via resource

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [SMARTY] direct way to handle mysql result sets (via resource

Erich Beyrent

2005-05-02, 4:00 pm

Jörg Hermsdorf wrote:
> Well, I'm not only looking for a simpler syntax.
> Think of an result set with 15 columns and 2000 rows.
> Considering memory and performance, I'm not sure if it
> is a good idea to create such an large array (15x2000
> fields) just to be able to display the result set
> using smarty... I'd prefer a solution without creating
> an array at all...

If you are dealing with a large array of that size, you are also going
to run into slowness when it comes time to render the data. This might
be better done as paged data, which will limit the size of your result
set and eliminate your memory concerns.

Sponsored Links