Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

Re^2: DBD::CSV eats memory

by perlmonkdr (Beadle)
on Nov 16, 2007 at 14:22 UTC ( #651212=note: print w/replies, xml ) Need Help??

in reply to Re: DBD::CSV eats memory
in thread DBD::CSV eats memory

Ok, thank, in this example I was tried to show how DBD::CSV eats memory in each loop, I was used a millon of rows becouse this's the way to see the increase of memory.

Anyway, I'll try then with SQLite or DBM::Deep.

Thank again for your help

Replies are listed 'Best First'.
Re^3: DBD::CSV eats memory
by jZed (Prior) on Nov 16, 2007 at 18:02 UTC
    You wrote "DBD::CSV" eats memory in each loop". How do you know that? Your script doesn't do any memory testting or profiling or printouts. And if it's true, what OS are you on and what versions of the software and its prerequisites are you using? (your version of DBI, for example is more than 5 years old).

      Hello Jeff,

      Yes, i'm following the increase of memory with "Task Monitor" on Windows XP..

      I finally updated DBI to v1.601, yours SQL::Statement to v1.15 and DBD::CSV to v0.22 and Text::CSV_XS to v0.30 and updated this example too,to see a bigger increment, but the problem continue, for 1000 loop eats around of 10MB of memory in my case.

      Well, thk U.

      PD:Let me know if you need some test.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://651212]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2018-12-15 00:47 GMT
Find Nodes?
    Voting Booth?
    How many stories does it take before you've heard them all?

    Results (69 votes). Check out past polls.