RE: count(*)

There is a difference between 10 and 120 minutes, especially on Friday.

> -----Original Message-----
> From: Anjo Kolk [mailto:anjo_at_oraperf.com]
> Sent: Friday, September 20, 2002 3:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: count(*)
>
>
> If you can live with 10 minutes, why not 60 minutes or 120 minutes ?
> Examine why this app feels so insecure that it needs to know
> the number of
> rows every 10 minutes.
>
>
> On Thursday 19 September 2002 20:28, you wrote:
> > Hi Gurus,
> >
> > In one of our insert intensive application we are inserting
> around 3-4
> > million rows / hour. Also this app needs to do a count(*)
> of the tables
> > every 10 minutes for verifying some application based
> logic. This is really
> > killing us and it takes a lot of time.
> >
> > Can you please guide me to a direction ( built in functions
> or something
> > similar).
> >
> > Actually this app is being ported from Informix. Informix
> can somehow keep
> > a trak of the count(*) of a table in its header somewhere.
> >
> > And yes I have tries count(1) , count(indexed_column) etc.
> >
> >
> > Thanks In Advance.
> >
> > R.h
>
> --
> ----------------------------------------------------------------
> Anjo Kolk
> http://www.oraperf.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anjo Kolk
> INET: anjo_at_oraperf.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).