Customization of authorize_reply_query
Hello I use the FR just to only authenticate the user. The data are stored in Oracle DD. Is there any option how to disable authorize_reply_query? The reason is that that DB contains millions of records and each query take some some time. Depending on DB load is 0.5 seconds but during the peak it goes up 7 seconds. As the users are authenticated after authorize_check_query, the reply query is in my case only delaying the authentication. Maybe there is some option how to set some static response for the reply query? Thank you Vaclav
On 02/10/12 13:35, Václav Pernica wrote:
Hello
I use the FR just to only authenticate the user. The data are stored in Oracle DD. Is there any option how to disable authorize_reply_query? The reason is that that DB contains millions of records and each query take some some time. Depending on DB load is 0.5 seconds but during the peak it goes up 7 seconds.
As the users are authenticated after authorize_check_query, the reply query is in my case only delaying the authentication. Maybe there is some option how to set some static response for the reply query?
Just set a null query e.g. select null where 1=0
Václav Pernica wrote:
I use the FR just to only authenticate the user. The data are stored in Oracle DD. Is there any option how to disable authorize_reply_query? The reason is that that DB contains millions of records and each query take some some time. Depending on DB load is 0.5 seconds but during the peak it goes up 7 seconds.
Set it to an empty string. And add indexes to the DB. There's no reason for a query to take 7s.
As the users are authenticated after authorize_check_query, the reply query is in my case only delaying the authentication. Maybe there is some option how to set some static response for the reply query?
Thats why it's editable: so you can edit it. Alan DeKok.
On Tue, Oct 2, 2012 at 7:35 PM, Václav Pernica <vpl@email.cz> wrote:
Hello
I use the FR just to only authenticate the user. The data are stored in Oracle DD. Is there any option how to disable authorize_reply_query?> The reason is that that DB contains millions of records and each query take some some time. Depending on DB load is 0.5 seconds but during the peak it goes up 7 seconds.
As the users are authenticated after authorize_check_query, the reply query is in my case only delaying the authentication. Maybe there is some option how to set some static response for the reply query?
authorize_reply_query, as the name implies, gets per-user reply items from db. If the table "contains millions of records" then most likely the one who designed the system (I'm guessing not you) have lots of per-user reply items there, or you might simply have lots of users. If you REALLY know what you're doing (the emphasis on REALLY), then you can create a new table with the same schema, and use it for ${authreply_table}. That way there will be no per-user reply items. -- Fajar
participants (4)
-
Alan DeKok -
Fajar A. Nugraha -
Phil Mayers -
Václav Pernica