Re: Record row count and execution time into table?

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Fri, 30 Sep 2005 17:07:53 +0200
Message-ID: <433d54c9$0$19492$ba620e4c@news.skynet.be>

"Snewber" <snew_at_snew.com> wrote in message news:dhi2u8$2g5p$1_at_bunyip2.cc.uq.edu.au...
>I was wondering if anyone knows the best way to count the number of rows in
>a table and enter this row count into a table along with how long the query
>took to execute?
>
> I realise that you can get both the row count and SQL execution time by
> turning timing on and then running the select count(*) ... but then I have
> to format the results and then do the insert into a table.
>
> Is there an easier way?

Strange question ... why do you need this ? The time a COUNT(*) takes can highly depend on factors as available disk i/o, indexes, buffer cache etc. I really see no use for it ?

Matthias Received on Fri Sep 30 2005 - 10:07:53 CDT