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

[Bogdan-Andrei Iancu]

Hi Henning,

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.

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.


I know this is a long shot, but first I want to experiment with usrloc 
and mysql to see if really makes a difference.

Regards,
Bogdan

Henning Westerholt wrote:
> On Wednesday 06 February 2008, Bogdan-Andrei Iancu wrote:
>   
>>> On Tuesday 05 February 2008, Bogdan-Andrei Iancu wrote:
>>>       
>>>> BTW, do you have any estimation (as time) about the start and end of
>>>> these changes? I plan also some major changes in the DB interaction and
>>>> preferable will be not to overlap ;)
>>>>         
>
> Hi Bogdan,
>
> sounds interesting, what type of chances do you plan? Just curious.. ;-)
>
> Cheers,
>
> Henning
>
>