Hi,
I made these kinds of tests before. I have two tips for you to pay attention to:
1. Read about the [routes] on SIPp, It is tricky to satisfy kamailio with SIPp scenarios.
2. Make sure your DB table is well build (use less varchars and more integers).
I found out that there are many kamailio modules I can use to load data in to memory and I hardly use the DB (only for ACC). I use MTREE, HTABLE, DIALPLAN, CARRIERROUTE, DROUTING, and so to store the information I need. And I get it with the simple functions of the module.
I load around 6 million numbers and other data which takes about 1.5 Gb of the memory.
For getting around the real-time changes that I need to deal with (In DB the data changes are immediately made on your service…). I have a RTIMER every 120 sec that check is a reload is needed. If so, it reloads the relevant data (very fast).
BR,
Uri