optimizing page with multiple recordsets and show ifs

[hconnorjr]

I'm creating a results page that will probably need multiple recordsets and show if regions. Is there a practical limit on recordsets and show if regions? The reason I'm using them is that some people will have information for some fields, but other people will not and I'd like the page to look clean. If person A has information for half the fields and person B has information for all of the fields, and person C has information for something in between, is there a good way of making this look clean? Thanks.
Mike

[Newsgroup_User]

Mike

I had had a page with 26 recordsets and it did not seem to have any
problems, however a lot of the performance issues may depend upon your
server. If you application language allows it thn it can pay to grab all the
information into one dataset and then run your subsequent queries from that.
In this way there is only one call on the database.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"hconnorjr" <webforumsuser@macromedia.com> wrote in message
news:ep3epj$nl9$1@forums.macromedia.com...
> I'm creating a results page that will probably need multiple recordsets
> and
> show if regions. Is there a practical limit on recordsets and show if
> regions?
> The reason I'm using them is that some people will have information for
> some
> fields, but other people will not and I'd like the page to look clean. If
> person A has information for half the fields and person B has information
> for
> all of the fields, and person C has information for something in between,
> is
> there a good way of making this look clean? Thanks.
> Mike
>

[hconnorjr]

Thanks for the reply. I'm not certain exactly how php/mySQL handles the information in a database connection vs a recordset. I'm using a single database connection in DW for all the recordsets . . .

[hconnorjr]

Does anyone else have thoughts about this in php/mysql? does each recordset connection with the database require server resources so that adding, say, 20 php/mysql will slow things down? i don't see an easy way to pull all the data and show particular regions only if the information is there.
Mike