[Bizgres-general] Bitmap Indexes : Block packing calculation error
Jim C. Nasby
jnasby at pervasive.com
Thu Jan 26 22:21:27 GMT 2006
On Thu, Jan 26, 2006 at 03:47:18PM +1300, Mark Kirkwood wrote:
> original:
>
> 9 s
> 20 s
> 17 s
>
> patched:
>
> 5 s
> 14 s
> 14 s
Maybe I'm just being greedy at this point, but shouldn't there have been
a more noticable change in performance from dropping the index size by a
factor of 8? Or are bitmap indexes just that expensive?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby at pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
More information about the Bizgres-general
mailing list