Subject Re: Table with more than 100 index.
Author svanderclock
Dear Ivan,

by ordering using index is slow, you mean in the insert (updating the index) or you mean in the select (using the select) ?


--- In, "Ivan Prenosil" <Ivan.Prenosil@...> wrote:
> > in this table around 50 000 000 records (and 20 fields)
> >
> > this index are motly here because we need to handle search and order for client in < 100 ms. so we need to index all possible case
> > of search
> But ordering using index is quite slow on the table of that size, your quieries will usually be slower than 100 ms anyway.
> Ivan