[Lazarus] data matrix with thousands of columns

Andrea Mauri andrea.mauri.75 at gmail.com
Tue Mar 26 15:38:57 CET 2013


Dear all,
I am looking for the best option in order to store big datasets with 
thousands of columns.
The dataset can contains from tens to hundred thousands lines and 
thousand of columns (some columns are string some numbers).
Which is the best option to store and retrieve information from a 
dataset like this?
Actually I am using sqlite, tens of tables including maximum 200 
columns. But I am not sure this is the best option.
Within my application I have to query this dataset:
- retrieve a particular line (all or some columns);
- retrieve a particular column (all or some lines);
- order the dataset with respect to a particular column;
- delete/add line(s);
- delete/add column(s);
...

SQLIte is easy to use when I need to query the dataset but I am not sure 
that is the most suitable.

Any hint?
Andrea Mauri




More information about the Lazarus mailing list