[SR-Users] pdb module best practice

[Thomas Baumann]

Hello,

I tested the pdb module and the pdb_server.  It is a fast solution even with a huge amount of numbers.

But how I can update the pdb_server in a fast and effective way ?  I tried it in the following way:

- number;carrier are stored in a mysql table (20 million entries)
- 2 pdb_servers are running
- the table is exported into a csv file (time: 5 seconds)
- pdbt will create a new mmappable file (time: 25 seconds)
- the pdb_servers will be restarted to activate the changes

The time of 30 seconds is good but not fast enought. 

Some of my numbers are updated very often, to export them and create a new mmappable file will take only 3 seconds.

I had the idea to split my numbers in a more or less static area and a dynamic area.  

What I want to do later is to have the pdb_server not static configured, I want to define the server within the request:

1. query in dynamic range:

pdb_query("$rU", "$avp(i:1000)", "localhost:10001,localhost:10002");

if not found look into the static area:

pdb_query("$rU", "$avp(i:1000)", "localhost:10003,localhost:10004");


Does it make sence, or has somebody a better idea how changes activated within 10s or less ?


regards,

Thomas
___________________________________________________________
Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief!  
Jetzt De-Mail-Adresse reservieren: https://produkte.web.de/go/demail02