> 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 ;)

Would it be acceptable for your users if the application could said
"The result of your query exceeded 10000 rows, please ask more specific question."
? And if yes, how low the limit could be ?

Ivan
http://www.volny.cz/iprenosil/interbase/