Jake Bunce
Well-known member
This confused me when I was trying to confirm the number of post records following my import. Phpmyadmin keeps reporting different row counts for xf_post. And I noticed it is using a tilda (~) which indicates an approximation:
But if I run this query it always returns the same number:
My vB database doesn't do this. I am guessing it's related to the InnoDB table type in xenForo?
Another interesting thing is that not all tables do this. Only the large tables show approximate counts:
But if I run this query it always returns the same number:
Code:
SELECT COUNT(*)
FROM xf_post
My vB database doesn't do this. I am guessing it's related to the InnoDB table type in xenForo?
Another interesting thing is that not all tables do this. Only the large tables show approximate counts: