Some benchmarks: First DBD::CSV latest from CPAN:
Using /root/.cpan/build/DBD-CSV-0.2001/blib Testing empty loop speed ... 100000 iterations in 0.2 cpu+sys seconds (624999 per sec) Testing connect/disconnect speed ... 2000 connections in 2.4 cpu+sys seconds (840 per sec) Testing CREATE/DROP TABLE speed ... 500 files in 3.7 cpu+sys seconds (135 per sec) Testing INSERT speed ... 500 rows in 2.1 cpu+sys seconds (240 per sec) Testing SELECT speed ... 100 single rows in 12.0 cpu+sys seconds (8.3 per sec) Testing SELECT speed (multiple rows) ... 100 times 100 rows in 13.4 cpu+sys seconds (7.5 per sec) Now DBD::SQLite 0.02, not released yet: Using /home/matt/DBD-SQLite/blib Testing empty loop speed ... 100000 iterations in 0.2 cpu+sys seconds (625000 per sec) Testing connect/disconnect speed ... 2000 connections in 3.6 cpu+sys seconds (552 per sec) Testing CREATE/DROP TABLE speed ... 500 files in 1.6 cpu+sys seconds (320 per sec) Testing INSERT speed ... 500 rows in 0.8 cpu+sys seconds (595 per sec) Testing SELECT speed ... 100 single rows in 0.4 cpu+sys seconds (227.3 per sec) Testing SELECT speed (multiple rows) ... 100 times 100 rows in 0.8 cpu+sys seconds (131.6 per sec) Issuing rollback() for database handle being DESTROY'd without explicit disconnect(). Anyone know how you "fix" that last thing? -- <!-- Matt --> <:->Get a smart net</:->
