Victor Gamov wrote:
Hi!
Can anybody say me: is OpenSER use prepared SQL statements?
AFAIK: no
regards
klaus
If "no" I think it must do it. It can increase productivity for many
modules using DB like REGISTRAR/USRLOC, ACC etc.
For modules allowing direct SQL statements (e.g. AVPOPS and ACC) it
possible to allow create and identify such queries as module parameter
and then call it. For example:
(in init section):
modparam("avpops", "prepared_sql", "QueryName='insert into tbl set
cell1=?, cell2=?")
(somewhere in route()):
avp_db_query("prepared:QueryName, value1, value2");
_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
