Re: Hundreds of columns, index on all of those.

rock_sand81@[EMAIL PROTECTED]
 wrote:

> I could not quickly find that information.
> 
> Or did you refer to the max amount of columns per one index?

No, it's a memory fault, thank you, you're right.

> I will give only the information which I gave already. The new items
> arrive, those will be kept in the DB for analysis (not for a very long
> time) and then the old items will be deleted. Items are not kept in
> the DB for a long time.

Since you don't use advanced RDBMS features, you might have better 
performance by following Ed's advice in his reply; for instance, in 
python land, I would go for pytables. I don't know about other
environments.