<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=Windows-1252"> <style type="text/css" style="display:none;"></style> </head> <body dir="ltr"> <div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif;" dir="ltr"> <p><br> </p> Hi Jeroen, <div><br> </div> <div>FYI none of the database working group chairs work for RIPE NCC any more.</div> <div><br> </div> <div>Kind regards,</div> <div><br> </div> <div>Scott Donald</div> <div>Comms-care</div> <div><br> <div style="color: rgb(0, 0, 0);"> <div> <hr tabindex="-1" style="display:inline-block; width:98%"> <div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Jeroen Massar <jeroen@massar.ch><br> <b>Sent:</b> 20 June 2017 12:22<br> <b>To:</b> db-wg@ripe.net<br> <b>Subject:</b> 2017 and RIPEdb only handles 700 updates per *MINUTE*</font> <div> </div> </div> </div> <font size="2"><span style="font-size:10pt;"> <div class="PlainText"><a href="https://www.ripe.net/analyse/statistics/ripe-database/ripedb-updates" id="LPlnk174654" previewremoved="true">https://www.ripe.net/analyse/statistics/ripe-database/ripedb-updates</a> <div id="LPBorder_GT_14979660302200.5339383947124865" style="margin-bottom: 20px; overflow: auto; width: 100%; text-indent: 0px;"> <table id="LPContainer_14979660302140.8074791924836251" role="presentation" cellspacing="0" style="width: 90%; background-color: rgb(255, 255, 255); position: relative; overflow: auto; padding-top: 20px; padding-bottom: 20px; margin-top: 20px; border-top: 1px dotted rgb(200, 200, 200); border-bottom: 1px dotted rgb(200, 200, 200);"> <tbody> <tr valign="top" style="border-spacing: 0px;"> <td id="ImageCell_14979660302150.9582423350410307" colspan="1" style="width: 250px; position: relative; display: table-cell; padding-right: 20px;"> <div id="LPImageContainer_14979660302150.2803284083381561" style="background-color: rgb(255, 255, 255); height: 226px; position: relative; margin: auto; display: table; width: 250px;"> <a id="LPImageAnchor_14979660302160.23666573331233653" href="https://www.ripe.net/analyse/statistics/ripe-database/ripedb-updates" target="_blank" style="display: table-cell; text-align: center;"><img id="LPThumbnailImageID_14979660302160.5064268654072996" width="250" height="226" style="display: inline-block; max-width: 250px; max-height: 250px; height: 226px; width: 250px; border-width: 0px; vertical-align: bottom;" src="https://www.ripe.net/logo.png"></a></div> </td> <td id="TextCell_14979660302170.12271453058452586" colspan="2" style="vertical-align: top; position: relative; padding: 0px; display: table-cell;"> <div id="LPRemovePreviewContainer_14979660302170.42236699835376856"></div> <div id="LPTitle_14979660302170.4689110610371445" style="top: 0px; color: rgb(0, 120, 215); font-weight: normal; font-size: 21px; font-family: wf_segoe-ui_light, "Segoe UI Light", "Segoe WP Light", "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; line-height: 21px;"> <a id="LPUrlAnchor_14979660302180.2525857922108714" href="https://www.ripe.net/analyse/statistics/ripe-database/ripedb-updates" target="_blank" style="text-decoration: none;">RIPE Database Server - Update Rate � RIPE Network ...</a></div> <div id="LPMetadata_14979660302180.7032254436839971" style="margin: 10px 0px 16px; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 14px;"> www.ripe.net</div> <div id="LPDescription_14979660302190.34784681641087856" style="display: block; color: rgb(102, 102, 102); font-weight: normal; font-family: wf_segoe-ui_normal, "Segoe UI", "Segoe WP", Tahoma, Arial, sans-serif; font-size: 14px; line-height: 20px; max-height: 100px; overflow: hidden;"> RIPE Database Server Update Rate. ... The smooth running of the Internet depends on the involvement of those who give their input on membership and policy issues.</div> </td> </tr> </tbody> </table> </div> <br> <br> <br> (see attached png for the current version as over time it will disappear)<br> <br> shows a nice peak with a max of 723.47 updates.<br> <br> Thus either the software is really bad, the updates are rate limited, or<br> the queries are so high that no further performance is to be expected.<br> <br> <br> As alluded to in the other thread, if there was less junk (those 400k<br> inet6nums for instance) then likely this would all scale better....<br> <br> Are the RIPE DB-WG chairs still actively involved in the maintenance of<br> the RIPE Database!?<br> <br> As two of the co-chairs are working for RIPE NCC, are they able to tell<br> why such a process is slow and why these problems that are being raised<br> over and over on the various lists are not being resolved?<br> <br> Greets,<br> Jeroen<br> </div> </span></font></div> </div> </div> </body> </html>