Apache2Xbase

The Apache2Xbase project now binds date & time stamps in apache log files to Java and SQL data-types respectively. Date and time sensitive queries are now possible. I knew that this was going to be the most difficult part of the project so it was good to set aside a quiet night to hammer it out.

The next challenge is to work with the SQL components and see if I can squeeze out better performance.

$ wc ../data/ccpmug/accesslog
   55306  716814 12328960 ../data/ccpmug/accesslog

$ wc ../data/bigwwwlog
  173483 2564610 39174144 ../data/bigwwwlog

$ time java mysql_test ../data/ccpmug/accesslog
Connection Established
Disconnected

real    1m48.265s
user    0m10.841s
sys     0m2.916s

$ time java mysql_test ../data/bigwwwlog
Connection Established
Disconnected

real    4m55.539s
user    0m30.733s
sys     0m8.234s

Apache2Xbase is released under the GPLv3 license (Free as in speech) at no charge (Free as in beer). My only request is to e-mail me if you find it useful.