Since this is the PHP DB list, I can tell you this -- you would be better off performance-wise replacing the "*" in "select * from" and replacing it with a list of the columns (even if it is all of them) than you would putting all of that on one line. $r = rand(0,7)*-1; $s = abs($r); is as fast as (maybe a few CPU cycles, but when you're talking 2GHz processor, eh) $s = abs(rand(0,7)*-1); The second is probably more elegant, but then again, you still have to check to see what $data contains -- the DB might not have returned a row (for some unknown reason). Optimize DB calls before compacting variables. I'm all about writing compact optimized code, but your DB calls and DB layout (indexes and queries mostly, but also table design) cost the most performance-wise and you're better off spending time getting them better. I highly recommend: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation.html#Estimating_performance Peter On Thu, 26 Jun 2003, Hugh Bothwell wrote: > "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 > --------------------------------------------------------------------------- Peter Beckman Internet Guy beckman@purplecow.com http://www.purplecow.com/ --------------------------------------------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
