Re: [Pytables-users] Question about pytables

[Francesc A. <fa...@op...>]

Vineet,

I've looked at your examples, and I think you are getting such a good
results with pytables because your data is completely repetitive and you are
using compression. In the real life, however, data is not so compressible
and you can be sure that this speed-up will decrease substantially.

Having said that, if your data is compressible (even a small amount)
pytables will have a clear advantage when reading over SQLite and large
amounts of data (tipically larger than your available system memory).
Besides, for creating tables, you can expect always much better performance
using pytables than a relational database. As always, your best bet is to
run the benchmarks with *real* data.

Cheers,

-- 
Francesc Alted