Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: count(*)
-----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
![]() |
![]() |