[plug] importing a large text database for fast search
carl.gherardi at gmail.com
Mon Sep 5 11:11:40 WST 2011
On Sun, Sep 4, 2011 at 12:56 PM, Michael Holland
<michael.holland at gmail.com> wrote:
> Thanks folks. Perl frontend with SQL datbase it is then.
> I'll go look at DBD::SQLite and DBIx::Class My PERL is rusty, but I like it.
For only 250k records you are probably ok, but SQLite DBs start to
become a bit unwieldy and slow once you hit the 2G mark.
My experience is with data mining rather than full test search so
ymmv, but i'd look at Lucene, MySQL or Postgres.
More information about the plug