<body bgcolor="#ffffff" background="https://img.web.de/v/p.gif" class="bgRepeatYes" style="background-repeat: repeat; background-color: rgb(255, 255, 255); color: rgb(0, 0, 0); font-family: verdana,geneva; font-size: 9pt; padding-left: 0px;"><div style="min-height: 200px; background-image: url(https://img.web.de/v/p.gif); background-repeat: repeat; background-color: #ffffff; font-family: verdana,geneva; font-size: 9pt; padding-left: 0px;">Hello,<br /><br />I tested the pdb module and the pdb_server. It is a fast solution even with a huge amount of numbers.<br /><br />But how I can update the pdb_server in a fast and effective way ? I tried it in the following way:<br /><br />- number;carrier are stored in a mysql table (20 million entries)<br />- 2 pdb_servers are running<br />- the table is exported into a csv file (time: 5 seconds)<br />- pdbt will create a new mmappable file (time: 25 seconds)<br />- the pdb_servers will be restarted to activate the changes<br /><br />The time of 30 seconds is good but not fast enought. <br /><br />Some of my numbers are updated very often, to export them and create a new mmappable file will take only 3 seconds.<br /><br />I had the idea to split my numbers in a more or less static area and a dynamic area. <br /><br />What I want to do later is to have the pdb_server not static configured, I want to define the server within the request:<br /><br />1. query in dynamic range:<br /><br />pdb_query("$rU", "$avp(i:1000)", "localhost:10001,localhost:10002");<br /><br />if not found look into the static area:<br /><br />pdb_query("$rU", "$avp(i:1000)", "localhost:10003,localhost:10004");<br /><br /><br />Does it make sence, or has somebody a better idea how changes activated within 10s or less ?<br /><br /><br />regards,<br /><br />Thomas<br /><span style="font-size: 9pt;"><span style="font-family: verdana,geneva;"><span style="background-color: transparent;"><span style="color: #000000;"><span style="color: #000000;"></span></span></span></span></span></div> <br><br><table cellpadding="0" cellspacing="0" border="0"><tr><td bgcolor="#000000"><img src="https://img.web.de/p.gif" width="1" height="1" border="0" alt="" /></td></tr><tr><td style="font-family:verdana; font-size:12px; line-height:17px;">Neu: WEB.DE De-Mail - Einfach wie E-Mail, sicher wie ein Brief! <br>Jetzt De-Mail-Adresse reservieren: <a href="https://produkte.web.de/go/demail02"><b>https://produkte.web.de/go/demail02</b></a></td></tr></table>
</body>