Re: Get a Random Row on a HUGE db

[Jigal van Hemert]

From: "Scott Gifford"

>    SELECT COUNT(*) FROM firebase_content;
>
> to get the count.  That's very fast; it comes from the table summary
> information, IIRC.  I use a similar solution for a similar problem,
> and have had great luck with it.
This is true for MyISAM tables, but e.g. InnoDB does *not* store the total
number of records per table seperately. A SELECT COUNT(*) on InnoDB will
result in a real row count...

Regards, Jigal.