From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM
	autolearn=ham autolearn_force=no version=3.4.4
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 103376,bb5076a9e9f85a34,start
X-Google-Attributes: gid103376,public
X-Google-ArrivalTime: 2003-08-14 06:57:58 PST
Path: archiver1.google.com!postnews1.google.com!not-for-mail
From: cbaskara@yahoo.co.in (baskar)
Newsgroups: comp.lang.ada
Subject: Table read before inserting a record using Recordset update
Date: 14 Aug 2003 06:57:57 -0700
Organization: http://groups.google.com/
Message-ID: <b5a71bcf.0308140557.209545e@posting.google.com>
NNTP-Posting-Host: 161.225.1.12
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060869478 19555 127.0.0.1 (14 Aug 2003 13:57:58
 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 14 Aug 2003 13:57:58 GMT
Xref: archiver1.google.com comp.lang.ada:41451
Date: 2003-08-14T13:57:58+00:00
List-Id: <comp.lang.ada>

Hi,

Trying to insert a record using the records section option
(rs.addNew()). I think it reads the whole table. I'm using the query
"select * from table where primary key = 1" for opening the record
set. My DBA is reporting that she is seeing "select * from table"
query is issued very frequently (where as we never issue this query
from any where else).

I'm suspecting that addNew() function reads the whole table before
inserting the record, but not sure. Any ideas or suggestions?

Thanks !

Regards,
Baskar