DB doesn't have num_rows/numRows ?? |
Why are you replying to every thread about this?
Why do you think performing a count() operation on the results array would be "wasting" CPU power but using mysql_num_rows or equivalent functions is free? (12-28-2020, 09:30 PM)ojmichael Wrote: Why are you replying to every thread about this?I'm sorry if it bothers you that I've responded to numerous threads. I had done a search of the forum and was hoping that one of the folks who were looking for this functionality might agree that it'd be useful to have the functionality. (12-28-2020, 09:30 PM)ojmichael Wrote: Why do you think performing a count() operation on the results array would be "wasting" CPU power but using mysql_num_rows or equivalent functions is free?I mentioned in this other thread that I searched the PHP source code for the MySQLi extension and it looks like the code just checks an integer value in memory rather than 1) creating data structures for a new string for the count query, 2) overwriting various Builder values set by a prior query, 3) sending this string to a DBMS (which might be running on an entirely different machine), 4) collecting, parsing, and buffering the result from the separate DBMS process.
(12-29-2020, 03:34 PM)sneakyimp Wrote:(12-28-2020, 09:30 PM)ojmichael Wrote: Why are you replying to every thread about this?I'm sorry if it bothers you that I've responded to numerous threads. I had done a search of the forum and was hoping that one of the folks who were looking for this functionality might agree that it'd be useful to have the functionality. You bothered a lot of people by replying to 2 years old threads. Please, start your own thread instead of hijacking very old threads like that! (12-29-2020, 06:22 PM)includebeer Wrote: You bothered a lot of people by replying to 2 years old threads. Please, start your own thread instead of hijacking very old threads like that!I apologize unreservedly. I was trying to avoid duplicate questions and hoping to interest folks with a prior interest in the topic. I will make my own post. |
Welcome Guest, Not a member yet? Register Sign In |