Subject | Re: [firebird-support] Table with more than 100 index. |
---|---|
Author | Ivan Prenosil |
Post date | 2009-12-07T23:23:56Z |
> in this table around 50 000 000 records (and 20 fields)But ordering using index is quite slow on the table of that size, your quieries will usually be slower than 100 ms anyway.
>
> 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
Ivan