[OpenSER-Devel] RFC: memory management in database modules

[Henning Westerholt]

On Friday 08 February 2008, Bogdan-Andrei Iancu wrote:
> I'm really interested in focusing on things that really drawback openser
> (as throughput) - and I do not refer at the non-sense lab tests (TM
> performances :P) which more or less have 0 relevance in real life
> scenarios.
>
> So, as a first plan, I wan to do some work on the DB part : I want to
> add support for prepared statements which will give some speed up in
> standard DB queries - 90% of the queries are standard and there is no
> need to prepare, build query, pass it to the driver, to parse it (by
> driver), etc.... I want first to add this support in usrloc module, only
> for mysql backend.


Hi Bogdan,

great that you plan to work on this problem. Prepared statements are also on 
my wish list.. :-) Do you plan also to change the DB API to only export a 
loading function (like in usrloc), as Daniel suggested?

> If the result are promising, we can extend this to all modules using DB.
> Then, we can investigate which other drivers support prepared statements
> and to enhance them also - if not native supported, we can do it the
> openser module.

Right, i also see no real need to change all modules to use prepared 
statements. We should concentrate on performance critical parts like usrloc 
and perhaps auth_db like you said.

Henning