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

[Back to original message]