Subject | Re: SV: [Firebird-Architect] Indexes for big objects |
---|---|
Author | Pavel Cisar |
Post date | 2006-07-09T16:47:52Z |
Nando Dessena wrote:
There is no difference between storing *unique* long field value (from
application) and storing any other *unique* field (hash). The mechanism
used to maintain uniqueness is the same - unique index.
best regards
Pavel Cisar
IBPhoenix
>Who is talking about maintaining uniqueness at the application level?
> apart from what Andrew Berg wrote, which I find entirely appropriate, I
> have to underline that you cannot reliably enforce uniqueness
> at the application level in a multi-user scenario, unless things
> changed while I wasn't watching.
There is no difference between storing *unique* long field value (from
application) and storing any other *unique* field (hash). The mechanism
used to maintain uniqueness is the same - unique index.
best regards
Pavel Cisar
IBPhoenix