Hi, I'm using FastBit library for running a count query using its example class ibis. But when I run a count query it gives more elapsed time than I run that query without counting. For example it gives more time for the query "SELECT COUNT(miles) WHERE gas>1500" when compared to "SELECT miles WHERE gas>1500". I need to know whether FastBit counts the records after loading the whole result set returned by "SELECT miles WHERE gas>1500" or use the indexed bitvectors for return the number of bits that satisfy where clause for counting. Or is there any other method.
Thanks, Sasini _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
