in reply to Re: fast+generic interface for range-based indexed retrieval
in thread fast+generic interface for range-based indexed retrieval

And if SQL can do the trick, but you want to avoid a full DBMS, you might look at DBD::SQLite
  • Comment on Re^2: fast+generic interface for range-based indexed retrieval

Replies are listed 'Best First'.
Re^3: fast+generic interface for range-based indexed retrieval
by CountZero (Bishop) on Dec 11, 2008 at 10:38 UTC
    A valid comment.

    However, as the OP was speaking of hundreds of millions of records, I wonder whether SQLite would scale well for such large databases? I have only used it for small projects, but if it can handle in an efficient way such large volumes, I might consider it in the future. Do you have any experience in that respect?

    CountZero

    A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

[reply]
[reply]

In Section Seekers of Perl Wisdom