[OpenSIPS-Users] Sqlops in opensips ?

[kokoska rokoska]

Brett Nemeroff napsal(a):
> Alex,
> I whole-heartedly agree with you here. I've seen a number of times that
> a slow DB query block worker threads and painfully holds up call
> processing. I think this is an inherent danger in interacting with the
> database in real-time. avp_db_query allows for this, and this allows for
> some sloppy programatic design. I also agree that the core of opensips
> would be well served by having a better architecture to deal with this
> kind of interaction to gracefully handle blocking scenarios. 
> 
> As it is right now, I believe if you use the DB API with a custom
> module, you still face the same challenges with not having POSIX threads
> and blocking queries. Right? It's not perfect, but I'm hoping that
> memcache can help with a lot of these needs. I'd like to see delayed ACC
> writes sometime as well..
> -Brett
> 

Synchronous ACC writes are one of the big "SER-like" performance
bottle-necks for me. So some kind of "caching" (delayd writes of bigger
chunks) would be very usefull :-)
Just my 2c...

Best regards,

kokoska.rokoska