Re: Efficiency question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Micah Stevens" <micah@raincross-tech.com> wrote in message
200306261904.27707.micah@raincross-tech.com">news:200306261904.27707.micah@raincross-tech.com...
> $data = mysql_fetch_assoc(mysql_query("select * from some_table limit
1"));
>
> would be faster than:
>
> $pointer = mysql_query("select * from some_table limit 1");
> $data = mysql_fetch_assoc($pointer);
>
> but I'm not sure, php may optimize this. Anyone know the answer?


It will be faster by one store and one fetch... the
database query probably takes 1000 times as long.
I don't think the difference is worth the time you'd
take to change it.

--
Hugh Bothwell     hugh_bothwell@hotmail.com     Kingston ON Canada
v3.1 GCS/E/AT d- s+: a- C+++ L++>+++$ P+ E- W+++$ N++ K? w++ M PS+
PE++ Y+ PGP+ t-- 5++ !X R+ tv b++++ DI+++ D-(++) G+ e(++) h-- r- y+




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux