RE: count(*)

From: Craig Munday <Craig.Munday_at_ecard.com.au>
Date: Sun, 22 Sep 2002 16:08:36 -0800
Message-ID: <F001.004D6242.20020922160836@fatcity.com>

RE: count(*)

Hi,

I've read so many suggestions for making this count(*) quicker but we are all assuming that it is needed and has a purpose in the first place - which may or may not be the case. Obviously the quickest way to do the count(*) is to NOT do it in the first place.

I'd still like to know the purpose of the count(*) and what verification it is performing? And also, why are there so many rows being inserted into the table.

Cheers,
Craig.

-----Original Message-----
From: Craig Munday [mailto:Craig.Munday@ecard.com.au]
Sent: Friday, 20 September 2002 10:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: count(*)

Hi,

I am not sure if I have a solution for you, but I have a number of questions:

1) just for my interest, what type of application would need to insert 3-4 million records per hour?

2) Why does the application need to do the select count(*)....? What verification is being performed?

3) Perhaps the design of the application could change so the number of records is reduced?

Cheers,
Craig.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Craig Munday
  INET: Craig.Munday_at_ecard.com.au

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).

Received on Sun Sep 22 2002 - 19:08:36 CDT