Re: Why Not MySQL?

> "Mitch Vincent" <mitch@huntsvilleal.com> writes:
> 
> Well, there's still a cost to having a lot of seldom-used indexes,
> because the planner has to sit there and consider whether to use each
> one for each query.  So I'd still recommend looking at your mix of
> queries and only creating indexes that match reasonably commonly-used
> WHERE clauses.
> 

 When doing insert/updates on larger tables (>500.000 entries) these
indexes are also time consuming !

 For our vertical attribute object storage systems we noticed, that
the time for insert/updates are the critical part - they behave very
linear in our test suite and they seem to be the limiting factor in
our system.


 Marten