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


Mime
View raw message