Re: [Pytables-users] indexing columns declaratively vs. afterwards

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

A Dijous 16 Desembre 2004 03:16, Andrew Straw va escriure:
> Hi again,
>=20
> A question/suggestion-for-the-docs:
>=20
> in section "6.2.2. Indexed searches" you don't mention if adding rows to=
=20
> a table with a column that was declared indexed is particularly=20
> expensive.  What are the speed tradeoffs involved with creating the=20
> index "on the fly" versus afterwards with .createIndex()?

Well, while I've not done extensive benchmarks on this, my impression is
that createIndex() would be a little bit faster, but not for a large extent.
However, you should take this as a feeling at first glance on my part.

If you have a better benchs on this subject I'll be happy to include your
results as part of the docs.

Cheers,

=2D-=20
=46rancesc Altet
Who's your data daddy? =A0PyTables