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

[Bogdan-Andrei Iancu]

Hi Henning,

Henning Westerholt wrote:
> 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?
>   

haven;t took this into consideration as it is more like cosmetics ;) - I 
want first to explore the technical aspect of the prepared statements 
and after that, why not, we can look for this.

Regards,
Bogdan
>   
>> 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.
>
>