in reply to Re^7: speeding up row by row lookup in a large db
in thread speeding up row by row lookup in a large db

There is a PDL module PDL::IO::DBI to make this straightforward. To make it scale Really Big, you'd probably need to read the data into something like CSV, then transform it into packed data, then memory-map that (on disk) using PDL::IO::FastRaw. Pull requests to make that more automatic would be most welcome!
  • Comment on Re^8: speeding up row by row lookup in a large db