|
|
Posted by Rik on 05/16/06 23:28
Rik wrote:
> I'm not enterily sure it's quicker though... My MySQL is still not as
> it should be.
And allthough it's rusty, some pointers for efficiency:
1. If you're not going to use the enumerated array, use mysql_fetc_assoc().
2. Only use the * in "SELECT * FROM table" if strictly necessary: The less
fields the faster:
Querying a 4 field, 900 rows table for all data 600 times:
Selecting 3 fields:
7.1682569980621
Selecting all fields by name:
7.5627238750458
Selecting *:
8.8992791175842
Grtz,
--
Rik Wasmus
Navigation:
[Reply to this message]
|