db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oystein.Grov...@sun.com (Øystein Grøvlen)
Subject Re: Optimized Inserts
Date Tue, 04 Jan 2005 08:09:30 GMT
>>>>> "WH" == Wil Hunt <wilh@lunarlogic.com> writes:

    WH>     The inserts that  are causing problems because I  don't know ahead
    WH>     of time if the record really is  an insert or not. I need to do a
    WH>     local read  to see  if the  record exists, and  if so,  perform an
    WH>     update instead of an insert.  This local read is taking about 45%
    WH>     of my  processing time,  which seems strange 

Why not just attempt an insert in the first place and then do an
update if the insert fails?

Øystein Grøvlen
Sun Microsystems
Trondheim, Norway

View raw message