which one to use mysqli_fetch_assoc OR mysqli_fetch_array from performance point of view?

Question

Our company is developing a big project in which all the things matter for us. So is there any benifit to use fetch_assoc() or is it just a shorcut for usability purposes?

Answer 1

Interesting question, it seems that fetch_assoc is slightly faster than fetch_array but I can't find a place talking about a significant difference.

mysqli_fetch_array($res, MYSQL_ASSOC);

is equivalent to

mysqli_fetch_assoc($res);

Personally, for big projects I prefer to use fetch_assoc as a debug friend too. The only significant difference between both functions will be the time you spend searching for bugs when something occurs or when the project needs an update. If there's a trouble with $row["id"], that's kinda easy to find out but $row[1] can be a real pain.