Welcome Guest, Not a member yet? Register   Sign In
Quick Table Stats?
#3

[eluser]zimco[/eluser]
You're right! I did a SELECT * FROM mytable then the query->num_rows()
Quote:If you’re grabbing everything from the table and then counting it, it will definitely be slow.

Thanks for the heads-up on the active record class>>count_all function. That was exactly what i was looking for! The user guide is amazing, maybe someday i'll remember to keep reading the whole section i'm in, before jumping right back into coding.

Thanks!


Messages In This Thread
Quick Table Stats? - by El Forum - 10-22-2008, 01:43 PM
Quick Table Stats? - by El Forum - 10-22-2008, 02:01 PM
Quick Table Stats? - by El Forum - 10-22-2008, 02:41 PM



Theme © iAndrew 2016 - Forum software by © MyBB