[Numpy-discussion] Pickle, pytables, and sqlite - loading and saving recarray's
Fri Jul 20 13:30:42 CDT 2007
A Divendres 20 Juliol 2007 20:16, Christopher Barker escrigué:
> Another small note:
> I'm pretty sure sqlite stores everything as strings. This just plain has
> to be slower than storing the raw binary representation (and may mean
> for slight differences in fp values on the round-trip). HDF is designed
> for this sort of thing, sqlite is not.
Yeah, that was the case with sqlite 2. However, starting with sqlite 3,
developers provided the ability to store integer and real numbers in a more
compact format . Sqlite 3 is the version included in Python 2.5 (the
python version that Vincent was benchmarking), so this shouldn't make a big
difference compared with other relational databases.
>0,0< Francesc Altet http://www.carabos.com/
V V Cárabos Coop. V. Enjoy Data
More information about the Numpy-discussion