Ok, so basically I build a temp table called "routes" from a stored proc. Can I not rely on this being a unique table per transaction if the session is held alive? Of course I could name the table something like routes_<timestamp>_<$ru> and trash it at the end of the stored proc. I just don't want to end up with a race condition.<div>
<br><br><div class="gmail_quote">On Thu, Jun 11, 2009 at 3:28 AM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@voice-system.ro">bogdan@voice-system.ro</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">Saśl Ibarra wrote:<br>
>> Each OpenSIPS process opens at startup a mysql connection and it keeps it<br>
>> open till the shutdown - so the connection is persistent at runtime. Of<br>
>> course, a conection can be re-established at runtime if some connection lost<br>
>> event happens (timesout etc).<br>
>><br>
>><br>
><br>
> That's good to know :) But don't you think it's a bit risky to rely on<br>
> temporary tables in this case? If by any chance the connection is lost<br>
> strange things ca start to happen :-O ? I'd go for memcache ;)<br>
><br>
</div>well, opensips takes care of its internal DB stuff (like re-init the<br>
prepared statements after a reconnect), but for other things you do by<br>
yourself from script, you need to take care by yourself :)<br>
<br>
But yes, the memcache is a good option :). especially that we are<br>
working on interfacing the memcache interface with the memcached daemon ;)<br>
<br>
Regards,<br>
<font color="#888888">Bogdan<br>
</font><div><div></div><div class="h5"><br>
_______________________________________________<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>
</div></div></blockquote></div><br></div>