On 14/12/2010 17:09, kokok_kokok wrote:
> I am building a Web server with Firebird 2.5. There are few clients (<10
> concurrently) but they can frozen the server if they do not use
> reasonable limits in their consults (for example they could query 20
> years of data, it means millions of records).
>
> It is really difficult to programmatically restrict the SQL queries.

If your web site is in PHP, you can also search firebird's php list
http://tech.groups.yahoo.com/group/firebird-php/messages
but AFAIR there's nothing magin in PHP runtime configuration for Firebird.

To change programaticcally, I'd change
"SELECT" to "SELECT FIRST 1000"
in critical statements.

HTH

Ciao.
Mimmo.