(RADIATOR) SQL "bind variables" ?

Ricardo Martinez rmartinez at redvoiss.net
Mon Aug 14 17:42:20 CDT 2006


Hello.
	I have a question regarding to the "AuthBy SQL".  We have several AuthBy for this type working fine.  Each AuthBy make a connection to a Oracle database.  The problem/question is ragarding to the performance in my DB.  As far as i know Radiator is making "inserts" like : 

insert into ACCOUNTING (ACCTDELAYTIME,ACCTSESSIONID,ACCTSTATUSTYPE,CALLEDSTATIONID,CALLINGSTATIONID,NASIPADDRESS,NASPORT,SERVICETYPE,SIPCSEQ,SIPFROMTAG,SIPMETHOD,SIPRESPONSECODE,SIPTOTAG,SIPTRANSLATEDREQID,USERNAME) values ('0','9831a498-91b9ca at 130.130.28.41','Stop','sip:584 at sip.mydomain.com,'sip:5591232 at sip.mydomain.com,'200.100.100.35','5060','Sip-Session','103','1fec2b5a740','8','200','5fdc88b54i0','sip:5591097 at 200.27.40.86:5060','55911232 at sip.mydomain.com')

and for each insert use the common instruction from above.  With this format the DB has to parse each "instruction" every time a new insert arrives, making the DB performance degrade.
Is possible for Radiator use "bind variables" to work with Oracle?.  With "bind variables" you only need to send the instruction one time : 

INSERT into temporal values (:value1,:value2)

and then only send the respective values, making the insertions much more efficient.  Is maybe this format implemented in Radiator? or is in the Roadmap?
Thanks !

Ricardo.-


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20060814/75f9912a/attachment.html>


More information about the radiator mailing list