Welcome Guest, Not a member yet? Register   Sign In
DB doesn't have num_rows/numRows ??
#11

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?
Reply
#12

(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.
Reply
#13

(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!
CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
Reply
#14

(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.
Reply




Theme © iAndrew 2016 - Forum software by © MyBB