Hello everyone,
I have a quick question of performance. Which is
faster with the Perl DBI:
1. One SQL query that retrieves a large amount of data
and then lets Perl decide what to do with each row.
i.e. this row is a "foo1" do this, this row is a
"foo2" do this.
2. Several SQL queries that segement the larger query
into several small queries. i.e. Perl does this to
all "foo1" from query #1. Perl does this to all "foo2"
from query #2. Etc...
I know this is really not specific enough for a
concrete answer but I was just wondering which is
'generally' more efficient.
Just wonderin' Thanks.
-Davin
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php