Re: selecting columns from a tab-separated-values file

[johngg]

in reply to selecting columns from a tab-separated-values file

You might be better off tolerating the expense of loading your data into a database of some sort once, perhaps SQLite, and thereafter take advantage of the speed of the database which is optimised for data look-ups, using SQL queries to access your columns. DBI and DBD::SQLite would facilitate this.

I hope this is helpful.

[ibm1620]

Interesting idea. Can SQLite handle that capacity? 10^9 rows and about 80GB of data total?

[Anonymous Monk]

give a go and you'll find out ;) or you can look here: http://sqlite.org/limits.html

[muba]

Hypertext is hypertext with hypertext references to hypertext documents: http://sqlite.org/limits.html