[OpenSIPS-Users] Mysql stored proc

[Brett Nemeroff]

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.

On Thu, Jun 11, 2009 at 3:28 AM, Bogdan-Andrei Iancu <bogdan at voice-system.ro
> wrote:

> Saúl Ibarra wrote:
> >> Each OpenSIPS process opens at startup a mysql connection and it keeps
> it
> >> open till the shutdown - so the connection is persistent at runtime. Of
> >> course, a conection can be re-established at runtime if some connection
> lost
> >> event happens (timesout etc).
> >>
> >>
> >
> > That's good to know :) But don't you think it's a bit risky to rely on
> > temporary tables in this case? If by any chance the connection is lost
> > strange things ca start to happen :-O ? I'd go for memcache ;)
> >
> well, opensips takes care of its internal DB stuff (like re-init the
> prepared statements after a reconnect), but for other things you do by
> yourself from script, you need to take care by yourself :)
>
> But yes, the memcache is a good option :). especially that we are
> working on interfacing the memcache interface with the memcached daemon ;)
>
> Regards,
> Bogdan
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.opensips.org/pipermail/users/attachments/20090611/2d5a401c/attachment.htm