| Subject | Limit the query via time or number of records |
|---|---|
| Author | kokok_kokok |
| Post date | 2010-12-14T16:09:14Z |
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.
What I am looking for is a way to define in Firebird the resources that can use each session. For example, I would like to define in Firebird that the maximum of time for a SQL consult is 30 seconds, and the number maximum of rows of any SQL statement is 5000.
Is it possible?
Thank you
It is really difficult to programmatically restrict the SQL queries.
What I am looking for is a way to define in Firebird the resources that can use each session. For example, I would like to define in Firebird that the maximum of time for a SQL consult is 30 seconds, and the number maximum of rows of any SQL statement is 5000.
Is it possible?
Thank you