www.digitalmars.com         C & C++   DMDScript  

digitalmars.D.learn - How to work with one very large text table but not in memory

reply Alain De Vos <devosalain71 gmail.com> writes:
I have one very large text table I want to work with.
But I don't want to keep de table in memory, what do I use ?
Using an sql database is overkill in my setting.
There are 10 colums but millions of rows.
Apr 06
next sibling parent =?UTF-8?Q?Ali_=c3=87ehreli?= <acehreli yahoo.com> writes:
On 4/6/21 12:55 PM, Alain De Vos wrote:
 I have one very large text table I want to work with.
 But I don't want to keep de table in memory, what do I use ?
 Using an sql database is overkill in my setting.
 There are 10 colums but millions of rows.
Jon Degenhardt of eBay uses D in similar ways with tsv-utils. He has good documentation here: https://github.com/eBay/tsv-utils I have a feeling one of his tools may already be useful to you. :) Personally, I would just parse the file line-by-line, potentially filtering, meanwhile building an array or an associative array and use the data from there. Ali
Apr 06
prev sibling parent tsbockman <thomas.bockman gmail.com> writes:
On Tuesday, 6 April 2021 at 19:55:03 UTC, Alain De Vos wrote:
 I have one very large text table I want to work with.
 But I don't want to keep de table in memory, what do I use ?
 Using an sql database is overkill in my setting.
 There are 10 colums but millions of rows.
You might find memory mapped files useful: http://phobos.dpldocs.info/std.mmfile.MmFile.html This allows D code to access the entire contents of the file as though it were a giant byte array in RAM, without requiring that there actually be enough physical RAM available to really do that. The OS is responsible for paging data to and from the disk as it is accessed.
Apr 06