one more thing. my data is more similar to a huge spreadsheet than a
relational DB, anyway I am looking for the best option already available
in lazarus/fpc to store and query the dataset
Il 26/03/2013 15:38, Andrea Mauri ha scritto:
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
--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
