in reply to Re^4: Efficient way to handle huge number of records?
in thread Efficient way to handle huge number of records?

I think that your formulation of "begin transaction" and "commit transaction" is more general and therefore better!

The PRAGMA stuff is specific to SQLite. It is possible to dynamically increase the size of the memory cache that SQLite uses and actually to decrease it later. I did it to speed up the indexing operation which is actually quite complex and builds a big memory structure to do it.

  • Comment on Re^5: Efficient way to handle huge number of records?

In Section Seekers of Perl Wisdom