[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