in reply to Re: Re: MySQL DBI Help
in thread MySQL DBI Help

It sounded to me like he was going to be selecting them all anyway so I don't really see a performance advantage. And the only resources that are being used here is a single value to store the email address. I don't see a lick of difference in whether it's done in the script or not.

You would definitely want to use the database resources for more sophisticated data retrieval. But this could be accomplished by just a flat file. Unless there's more to the script than just reading out these addresses, i'd actually go with a flat file instead.

Replies are listed 'Best First'.
Re: Re: Re: Re: MySQL DBI Help
by suaveant (Parson) on Sep 22, 2001 at 21:50 UTC
    He wants to view 30 at a time... when he says very large page I assume cgi... but granted, if it is going to be a system script the only thing you would save in doing multiple selects with LIMIT would be memory, and chances are it would be better to select it all... if it is a cgi, using LIMIT is probably best.

                    - Ant
                    - Some of my best work - Fish Dinner