I have several htables with various amounts of data in them ranging from a couple hundred entries to a couple million entries and while the reload itself does take a bit, the vast majority of the delay is the database -> Kamailio loading
time. Once the data is in there, the pointer updates haven’t been anything I’ve noticed. I’m sure it takes some measurable amount of time, but in my case it’s so imperceptible that it’s irrelevant.
Brooks Bridges
1200 S. Rogers Circle, Unit 6
Boca Raton, FL 33487
Office:
916-235-2097
Main:
888-444-1111
email:
bbridges@call48.com | web:
www.call48.com
From: sr-users <sr-users-bounces@lists.kamailio.org>
On Behalf Of David Villasmil
Sent: Thursday, April 7, 2022 08:09
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: Re: [SR-Users] Htable reload
Thanks Alex, I'm wondering how this will affect performance if there are many thousands or even millions of records...
On Thu, Apr 7, 2022 at 4:03 PM Alex Balashov <abalashov@evaristesys.com> wrote:
No, the reload actually creates a temporary new hash table (in heap), loads the entries from the DB into it, then iterates through the buckets of that temporary table and replaces the entries (pointers) in the existing table with the entries from the temporary table, then frees the buckets in the temporary table.
> On Apr 7, 2022, at 4:43 AM, David Villasmil <david.villasmil.work@gmail.com> wrote:
>
> Hello all,
>
> I’ve been trying to figure out how htable reloads happen. Does it replaces the existing one or creates a new one, populates it from the db and then renames it? The latter would be (I think) ideal, even if it uses more resources.
>
> Thanks!
>
> David
> --
> Regards,
>
> David Villasmil
> email: david.villasmil.work@gmail.com
> phone: +34669448337
> __________________________________________________________
> Kamailio - Users Mailing List - Non Commercial Discussions
> * sr-users@lists.kamailio.org
> Important: keep the mailing list in the recipients, do not reply only to the sender!
> Edit mailing list options or unsubscribe:
> * https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
* sr-users@lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
* https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users