Hi, I am trying to setup Fastbit on linux. I have been able to load star sample data file successfully.
My query runs slower first time, and then faster next time and then faster (sometimes) one more time but it really slows down next time. Though the query output shows CPU time taken is .004 secs but the query actually returned in 125 secs. It happens alternatively. [preetigupta25@dhalsim examples]$ ./fastbit.sh Constructed a part named s0 filter::sift2(SELECT avg(charge) FROM 1 data partition WHERE 90 < z ...) -- processing data partition s0 countQuery::evaluate -- Select count(*) From s0 Where 90 < zdc --> 5536 countQuery::evaluate -- duration: 0.001 sec(CPU), 0.00105953 sec(elapsed) tableSelect -- select(avg(charge), zdc>90) on table T-s0 produced a table with 1 row and 1 column tableSelect -- the result table (1 x 1) for "SELECT avg(charge) FROM T-s0 WHERE zdc>90" 17.1549855491329 tableSelect:: complete evaluation of SELECT avg(charge) FROM T-s0 WHERE zdc>90 took 0.003 CPU seconds, 0.00379491 elapsed seconds /home/preetigupta25/FastBit/fastbit-ibis1.3.3/examples/.libs/lt-ibis -- total CPU time 0.004 s, total elapsed time 0.00450182 s It took 0 seconds [preetigupta25@dhalsim examples]$ ./fastbit.sh Constructed a part named s0 filter::sift2(SELECT avg(charge) FROM 1 data partition WHERE 90 < z ...) -- processing data partition s0 countQuery::evaluate -- Select count(*) From s0 Where 90 < zdc --> 5536 countQuery::evaluate -- duration: 0.001 sec(CPU), 0.00106502 sec(elapsed) tableSelect -- select(avg(charge), zdc>90) on table T-s0 produced a table with 1 row and 1 column tableSelect -- the result table (1 x 1) for "SELECT avg(charge) FROM T-s0 WHERE zdc>90" 17.1549855491329 tableSelect:: complete evaluation of SELECT avg(charge) FROM T-s0 WHERE zdc>90 took 0.004 CPU seconds, 0.00384116 elapsed seconds /home/preetigupta25/FastBit/fastbit-ibis1.3.3/examples/.libs/lt-ibis -- total CPU time 0.005 s, total elapsed time 0.0045433 s It took 125 seconds The script contains only one command #!/bin/bash START=$(date +%s) # do something # start your script work here # your logic ends here test='./ibis -d s0 -v -q "select avg(charge) where zdc>90"' eval $test END=$(date +%s) DIFF=$(( $END - $START )) echo "It took $DIFF seconds"
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
