|Subject||Re: [firebird-support] Limit the query via time or number of records|
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
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.