19 Aug
2024
19 Aug
'24
1:21 p.m.
Hello,
my recommendation would be to adapt your data model and possible review your query design.
40 million records will not hit the limits for a proper relational database.
You are trying to do something with Kamailio which the software was not optimized for.
What module you are using for this?
With htable for example you will get not a great performance as it will mostly degrade to
a linear list search due to the smaller number of available hash buckets.
Cheers,
Henning
-----Original Message-----
From: elhar.mohamed--- via sr-users <sr-users(a)lists.kamailio.org>
Sent: Montag, 19. August 2024 12:41
To: sr-users(a)lists.kamailio.org
Cc: elhar.mohamed(a)gmail.com
Subject: [SR-Users] Re: low performance with udp_children and
async_workers
Hello ,
We've two tables that contains arround 40M of records, so with relational
database it's complicated to fetch data. That why we're loading the data in the
shm when the kamailio is starting.
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe
send an email to sr-users-leave(a)lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the
sender!
Edit mailing list options or unsubscribe: