[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