Hello,
i could be wrong but what i read from perlvdb is that using that module you abstract from the DB engine. I want to know if it's posible with this module to load a database in memory. I want to do this for performance. if is posible could you give an example, otherwise you could give a hint to solve this
thanks
bye
Hello,
if you want to load database tables in memory, check the htable and sqlops modules (they are available on Kamailo trunk - to be released as 1.5.0 in 1-2 months): http://kamailio.org/docs/modules/devel/htable.html http://kamailio.org/docs/modules/devel/sqlops.html
Cheers, Daniel
On 01/12/2009 08:48 PM, victorpy wrote:
Hello,
i could be wrong but what i read from perlvdb is that using that module you abstract from the DB engine. I want to know if it's posible with this module to load a database in memory. I want to do this for performance. if is posible could you give an example, otherwise you could give a hint to solve this
thanks
bye
ok i'll check them.
thanks
miconda wrote:
Hello,
if you want to load database tables in memory, check the htable and sqlops modules (they are available on Kamailo trunk - to be released as 1.5.0 in 1-2 months): http://kamailio.org/docs/modules/devel/htable.html http://kamailio.org/docs/modules/devel/sqlops.html
Cheers, Daniel
On 01/12/2009 08:48 PM, victorpy wrote:
Hello,
i could be wrong but what i read from perlvdb is that using that module you abstract from the DB engine. I want to know if it's posible with this module to load a database in memory. I want to do this for performance. if is posible could you give an example, otherwise you could give a hint to solve this
thanks
bye
-- Daniel-Constantin Mierla http://www.asipto.com
Kamailio (OpenSER) - Users mailing list Users@lists.kamailio.org http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
Hi,
On Monday 12 January 2009, victorpy wrote:
I want to know if it's posible with this module to load a database in memory.
yes, that would be possible, but ...
I want to do this for performance.
... the transition to the Perl layer consumes more time than the database requirests themselves. In other words: perlvdb is much slower than regular database requests, even _without_ querying any database at all.
Use Daniel's hints. :)
Best Bastian
Hello,
On 01/13/2009 10:18 AM, Bastian Friedrich wrote:
Hi,
On Monday 12 January 2009, victorpy wrote:
I want to know if it's posible with this module to load a database in memory.
yes, that would be possible, but ...
I want to do this for performance.
... the transition to the Perl layer consumes more time than the database requirests themselves. In other words: perlvdb is much slower than regular database requests, even _without_ querying any database at all.
that depends on how fast is DB -- anyhow, going to it via perl is definitively slower.
On the other hand, probably using perl and create a cache is perl share memory could be faster when dealing with exotic data storage systems.
Cheers, Daniel
Use Daniel's hints. :)
Best Bastian
On Monday 12 January 2009, victorpy wrote:
i could be wrong but what i read from perlvdb is that using that module you abstract from the DB engine. I want to know if it's posible with this module to load a database in memory. I want to do this for performance. if is posible could you give an example, otherwise you could give a hint to solve this
Hi victorpy,
another option would be to just use mysql with the MEMORY storage engine. It stores all data in a memory structure.
http://dev.mysql.com/doc/refman/5.0/en/memory-storage-engine.html
Cheers,
Henning
-
Bastian Friedrich -
Daniel-Constantin Mierla -
Henning Westerholt -
victorpy