db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Hallgren <tho...@tada.se>
Subject Re: Derby with fast transactions?
Date Tue, 21 Feb 2006 16:10:02 GMT
Andre Höing wrote:
> Every time i get a single triple or a group of them from another node in the
> network (a DHT Network), I have to check if I already saved a Triple with that
> Subject Predicate and Object and if not I have to insert it.
> Thanks a lot for your help.
Make sure you have a combined unique constraint on the triple.Put the most unique column 
first in that constraint. Skip the check altogether. Simply insert the record. If it's a 
duplicate, the insert will fail on a unique key violation.

Kind Regards,
Thomas Hallgren

View raw message