Skip Menu |

This queue is for tickets about the DBD-SQLite CPAN distribution.

Report information
The Basics
Id: 20288
Status: rejected
Priority: 0/
Queue: DBD-SQLite

People
Owner: Nobody in particular
Requestors: MUIR [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in:
  • 1.11
  • 1.12
Fixed in: 0.31



Subject: DBD::SQLite leaks lots of memory
DBD::SQLite uses *lots* more ram to run the regression tests for my OOPS module than any of the rest of my backend databases (DBD::SQLite2, DBD::mysql, DBD::Pg). How to repeat: Download OOPS 0.1004 from CPAN. You'll also need: a recent Data::Compare, Time::HiRes, Test::MultiFork, Clone::PP. Open two windows. In window #1: The your OOPSTEST_DSN environment variable to: DBI:SQLite2:dbname=/tmp/sqlite2.$$.db" In Window #2: Set your OOPSTEST_DSN environment variable to: DBI:SQLite:dbname=/tmp/sqlite.$$.db" In both windows: Run t/slowtest.t. Use ^S and ^Q to pause them as they run. Stop both of them when they've said "ok" about 9700 times. Then run a "ps" command that shows you how much memory is used by each process. My results: RAM on-disk database size DBD::SQLite 33.7MB 748K DBD::SQLIte2 13.9MB 1140K DBD::mysql 13.5MB na DBD::Pg 15.7MB na I forget which one, but on one of my regression tests, DBD::SQLite ballooned up to over 300MB.