I noticed that store has a ‘compressed’ option, but was unsure what
advantages/disadvantages are associated with it versus using the normal
or ‘yes’ option. Does anyone know?
Cheers!
On Dec 5, 2006, at 23:53, Raymond O’connor wrote:
I noticed that store has a ‘compressed’ option, but was unsure what
advantages/disadvantages are associated with it versus using the
normal
or ‘yes’ option. Does anyone know?
Hey …
the compressed value is stored in the index, not the uncompressed
(plain) …
keeps the index small, but you need cpu cycles to uncompress the
data, if you
access them or want to sort by them… i guess it depends on the size
of the
data you want to store, typical queries, the size of your index and
maybe the
speed of your hard disk 
Ben