Using large files

Opening an over 0.5GB csv text file with 20 columns and around 3.5 million rows can take several seconds on a low end pc.
Loading about 12GB MySql *.sql file with over 10 million records and Long Text (Memo) fields can take around 2 minutes.
Filling a field in a 150 million record set with some 1...n sequence will take a few seconds. Same as filtering it using regular expressions.
150 million records with four text field containing up to several characters each with calculated fields and formulas can use around 15GB of RAM.