avp_db_store is to write avps back to the avp table. <div><br class="webkit-block-placeholder"></div><div>You can do all SQL queries with the avp_db_query function. It's fantastic.</div><div><br class="webkit-block-placeholder">
</div><div>Just remember, SQL transactions take time and will affect your overall performance. Some of the built in functions are more efficient in terms of processing which include capabilities such as memory caching.</div>
<div><br class="webkit-block-placeholder"></div><div>For example, you can do LCR lookups entirely with avp_db_query (I've done this). But the LCR module in it's present revision caches everything. Which on a larger scale, really makes all the difference. I've worked with a number of different sized providers, nothing gigantic, but some doing multiple DS3s of traffic, and avp_db_query hasn't been too slow to handle it yet.</div>
<div><br class="webkit-block-placeholder"></div><div>-Brett</div><div><br><br><div class="gmail_quote">On Fri, Jan 30, 2009 at 9:28 AM, Matti Zemack <span dir="ltr"><<a href="mailto:Matti.Zemack@rtcfactory.com">Matti.Zemack@rtcfactory.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Thanks Brett. (This mailing list is fantastic...)<br>
<br>
<br>
Working fine now with avp_db_query.<br>
<br>
I might stick with the 'usr_preferences', but still use the avp_db_query<br>
as it makes coding a bit simpler "controllable" for me as I don't yet<br>
fully understand the avp_db_store-command.<br>
<br>
Oh, I wish there would be more config examples easy accesible on one web<br>
page. Probably what I'll do when I know more. :-)<br>
<br>
<br>
Best Regards and have a wonderful weekend,<br>
<font color="#888888">Matti Zemack<br>
Stockholm<br>
Sweden<br>
</font><div class="Ih2E3d"><br>
<br>
-----Original Message-----<br>
From: <a href="mailto:brett@nemeroff.com">brett@nemeroff.com</a> [mailto:<a href="mailto:brett@nemeroff.com">brett@nemeroff.com</a>]<br>
Sent: den 29 januari 2009 16:15<br>
To: Matti Zemack; <a href="mailto:users-bounces@lists.opensips.org">users-bounces@lists.opensips.org</a>;<br>
<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a><br>
</div><div class="Ih2E3d">Subject: Re: [OpenSIPS-Users] Talking to my own MySQL-table<br>
<br>
I do the same. Use avp_db_query.<br>
-Brett<br>
<br>
<br>
Sent from my Verizon Wireless BlackBerry<br>
<br>
-----Original Message-----<br>
From: "Matti Zemack" <<a href="mailto:Matti.Zemack@rtcfactory.com">Matti.Zemack@rtcfactory.com</a>><br>
<br>
Date: Thu, 29 Jan 2009 15:57:48<br>
To: <<a href="mailto:users@lists.opensips.org">users@lists.opensips.org</a>><br>
Subject: [OpenSIPS-Users] Talking to my own MySQL-table<br>
<br>
</div><div class="Ih2E3d">Hi all,<br>
<br>
Still being a newbie, I've been off and on thinking about the following<br>
for the last few days.<br>
What module should I use (or rather what's the smartest approach) for<br>
the following scenario;<br>
* If I have my own home made table in the "opensips"-database. How<br>
can I insert and delete rows from it? Basically what I would like to<br>
make is a storage of the latest REGISTER try from any one account. When<br>
a new REGISTER is tried from that account the old gets deleted.<br>
Basically all I want to save is $fu. What module is applicable, and how<br>
could I use it?<br>
Why not in "usr_preferences" you may ask, well I would like a solution<br>
which is easily deployed and upgradeable without interfering with the<br>
standardized database schema. Or is "usr_preferences" the best way to<br>
go?<br>
<br>
Thankful for any answers,<br>
Matti Zemack<br>
Stockholm<br>
Sweden<br>
</div><div><div></div><div class="Wj3C7c">_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br>
<br>
</div></div></blockquote></div><br></div>