yes unfortunatly i guess that the 100 ms will not be respected (actually a test on 8 000 000 row and it's around 5 seconds, so i thing we will be around 100 ms for 80 000 000 row). most important is to not be around 10 seconds ;)

--- In firebird-support@yahoogroups.com, "Ivan Prenosil" <Ivan.Prenosil@...> wrote:
>
> >> Yes, SELECT. Can you try yourself ? Construct SELECT statement with WHERE
> >> clause that will return e.g. 150 rows,
> >> and execute it on your 50 000 000 records table, once ORDERed by index,
> >> once withou index, and compare the times.
> ...
> > "first rows" could be faster when using the index though, can't it Ivan?
>
> Yes, but not as fast as one would expect (i.e. the 100 ms limit will most probably be exceeded)
>
> Ivan
>