As I know something about SQL engine it combine several indices for one searching condition and ORDER BY is not created upon index but it is created upon sorting of result set. So I am sure that all those indices are your bottleneck.

Regards,

Djordje Radovanovic

----- Original Message -----
From: svanderclock
To: firebird-support@yahoogroups.com
Sent: Wednesday, March 03, 2010 15:15
Subject: [firebird-support] Re: commit after insert is very slow



i forget to say that it's meanly because of different "order by" choice that i need all thoses index ...

--- In firebird-support@yahoogroups.com, "svanderclock" <svanderclock@...> wrote:
>
> yes absolutely of absolutely (of the absolutely) sure that i need all thoses index ! and 30 index for one table is not look too much exagerated :(
>
>
> --- In firebird-support@yahoogroups.com, "Ivan Prenosil" <Ivan.Prenosil@> wrote:
> >
> > > > Are you absolutely sure that you really need all these indexes?
> > >
> > > sure, and absolutely sure ! because it's a critical that select query return in < 100 ms, and for that we need all theses index :(
> >
> > Are you absolutely sure that you are absolutely sure ?
> >
>





[Non-text portions of this message have been removed]