On Mon, 30 Oct 2006, Igor Tandetnik wrote:
> Date: Mon, 30 Oct 2006 11:21:15 -0500
> From: Igor Tandetnik <[EMAIL PROTECTED]>
> Reply-To: sqlite-users@sqlite.org
> To: SQLite <sqlite-users@sqlite.org>
> Subject: [sqlite] Re: efficient way to figure out if a table is empty
>
> Xavier Noria <[EMAIL PROTECTED]> wrote:
> > Not that is critical for my application, but just for curiosity which
> > is the recommended idiom to figure out whether a table has any
> > register?
>
> select exists (select * from tablename);
>
> Igor Tandetnik
Would it not make sense to use the limit on the subquery to reduce
overhead in the case where the table is populated?
select exists( select * from tablename limit 1 );
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
