<?xml version="1.0" encoding="windows-1252"?>
<node id="651111" title="Re: DBD::CSV eats memory" created="2007-11-15 21:17:40" updated="2007-11-15 16:17:40">
<type id="11">
note</type>
<author id="67275">
jZed</author>
<data>
<field name="doctext">
I'm not sure what your test is supposed to illustrate or what you think memory has to do with speed in this case, but as the maintainer of [mod://DBD::CSV] I can assure you that it was not built to handle a million rows quickly.  Use SQLite or a full RDBMS for data sets of that size.  That said, there are some big speed improvements coming to DBD::CSV soon (a new version of its SQL engine [mod://SQL::Statement]).  I'll announce it on this site when its ready.</field>
<field name="root_node">
651110</field>
<field name="parent_node">
651110</field>
</data>
</node>
