Subject | Re: SV: [Firebird-Architect] Indexes for big objects |
---|---|
Author | Nando Dessena |
Post date | 2006-07-09T15:26:34Z |
Pavel,
P> Sorry, still can't see why it would be good to have it built in the
P> system, when you can solve that easily at "application" level, i.e. use
P> hashes and queries like:
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.
P> What many people would really want is quick search for value parts in
P> long values (STARTING WITH, CONTAINING)
Sure, but this is a completely different matter. I'd like to have
stored functions, by the way, but doesn't mean I can't see the value
in indexing large objects. ;-)
Ciao
--
Nando Dessena
P> Sorry, still can't see why it would be good to have it built in the
P> system, when you can solve that easily at "application" level, i.e. use
P> hashes and queries like:
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.
P> What many people would really want is quick search for value parts in
P> long values (STARTING WITH, CONTAINING)
Sure, but this is a completely different matter. I'd like to have
stored functions, by the way, but doesn't mean I can't see the value
in indexing large objects. ;-)
Ciao
--
Nando Dessena