• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.