(RADIATOR) Optimising Oracle queries in Radiator

[Hugh Irvine]

Hello Denis -

You can either use stored procedures with the AuthBy PLSQL clause 
contained in the "goodies" directory, and/or you can use bind variables 
in the AddressAllocator clause. See the example in 
"goodies/addressallocator.cfg".

regards

Hugh


On 12 May 2004, at 10:15, Denis Dowling wrote:

> Just wondering if anyone has done any work on optimizing how the auth
> queries are performed. We are using Radiator 3.9 connected to an Oracle
> database. I notice that all of the queries are "prepare" and "execute" 
> for
> every single auth. Given that the only thing that changes between 
> queries is
> the username then surely some sort of parameter binding would be a big
> performance win.
>
> Any other hints on how to speed up auth from an Oracle database?
>
> Regards,
> Denis
>
>
> --
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.