Hi, Preeti, Would you mind to run
time ./ibis -d s0 -v -q "select avg(charge) where zdc>90" and see what is reports? Which one of the STAR sample data you are using? John On 11/18/12 3:00 PM, preeti gupta wrote: > 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 > _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
