Hi John,
We have compared two cases:
Case 1. running programs built with fastbit 1.3.8, on index files
built using 1.3.8.
Case 2. running programs built with fastbit 2.0.2, on index files
built using 1.3.8.
With everything same, and no single line change on our programs. The case 1 was
run first.
The case 1 (1.3.8 program on 1.3.8 index files) is at least 3X faster.
The comparison using "2.0.2 ibis" and "1.3.8 ibis" showed the same behavior.
Out query is simple: 'select count(1) WHERE COL_A contains "com.google.com" and
COL_B=0'.
There are about 60M records in index files.
COL_A, COL_B are defined below as in "-part.txt":
=====================================================================
Begin Column
name = "COL_A"
description = COL_A
data_type = "TEXT"
index=keywords delimiters=";"
End Column
Begin Column
name = "COL_B"
data_type = "INT"
minimum = 0
maximum = 2
index = <binning none/><encoding equality/>
End Column
=====================================================================
Question: Is it the expected behavior, or we did something wrong?
Thanks
Jilong Wang
_______________________________________________
FastBit-users mailing list
[email protected]
https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
