Come for the quick hacks, stay for the epiphanies. | |
PerlMonks |
Re^3: Efficient search through a huge datasetby pg (Canon) |
on Oct 20, 2004 at 02:11 UTC ( [id://400738]=note: print w/replies, xml ) | Need Help?? |
Millions of records? Not true at all! You can do simply one query, say you want to find out all records that are in table1 but not table2, then you can either:
Or (if munus is supported):
It should be easy for you to modify the query a bit to satisfy your needs.
In Section
Seekers of Perl Wisdom
|
|