in reply to Re^4: Efficient search through a huge dataset
in thread Efficient search through a huge dataset

You don't have to group EVERYTHING. Grouping inserts into chunks of reasonable size make them faster, even if you have to insert one million records.

Please refer to the SQL docs.

  • Comment on Re^5: Efficient search through a huge dataset

In Section Seekers of Perl Wisdom