Mysql_result vs mysql_array_assoc

Question

Is there a performance difference between using mysql_result and mysql_array_assoc to cycle through a large SQL selection result?

Answer 1

On the mysql_result () page :

When working with large sets of results, you should consider using one of the functions that retrieve the whole string (indicated below). Since these functions return the contents of several cells in a single function call, they are MUCH faster than mysql_result (). Also, note that specifying a numerical offset for a field argument is much faster than specifying a field name or tablename.fieldname.

, , mysql_array_assoc(), , , .

Answer 2

( , mysql_result), mysql_result:

, (mysql_fetch_ *). , , mysql_result()