Fetchrow questionby alainb (Initiate)
|on Mar 20, 2012 at 20:56 UTC||Need Help??|
alainb has asked for the
wisdom of the Perl Monks concerning the following question:
Hi I have a question, and tryed to find the response without success.
When someone use DBI ODBC
if you do a select
$request = "select var1,var2,var3 from table";
$var1,$var2,$var3) = $Sth1->fetchrow();
what exactly happen, I mean internaly?
Do the $Sth->execute() read the entire table and put it into an array in memory?
Do the $Sth->fetchrow() read one row from the array in memory?
OR it return some pointer than the fetchrow read one record from that table on disk at the time?