Script to automatically warm the postgresql query before sending traffic

diff --git a/utils/warm.php b/utils/warm.php
new file mode 100755 (executable)
index 0000000..923e2ab
--- /dev/null
+++ b/utils/warm.php
@@ -0,0 +1,63 @@
+#!/usr/bin/php -Cq
+<?php
+
+        require_once(dirname(dirname(__FILE__)).'/lib/init-cmd.php');
+        ini_set('memory_limit', '800M');
+
+       $aCMDOptions = array(
+               "Tools to warm nominatim db",
+               array('help', 'h', 0, 1, 0, 0, false, 'Show Help'),
+               array('quiet', 'q', 0, 1, 0, 0, 'bool', 'Quiet output'),
+               array('verbose', 'v', 0, 1, 0, 0, 'bool', 'Verbose output'),
+               array('reverse-only', '', 0, 1, 0, 0, 'bool', 'Warm reverse only'),
+               array('search-only', '', 0, 1, 0, 0, 'bool', 'Warm reverse only'),
+       );
+       getCmdOpt($_SERVER['argv'], $aCMDOptions, $aResult, true, true);
+
+       require_once(CONST_BasePath.'/lib/log.php');
+       require_once(CONST_BasePath.'/lib/Geocode.php');
+       require_once(CONST_BasePath.'/lib/PlaceLookup.php');
+       require_once(CONST_BasePath.'/lib/ReverseGeocode.php');
+
+       $oDB =& getDB();
+
+       $bVerbose = $aResult['verbose'];
+
+       if (!$aResult['search-only']) {
+
+               $oReverseGeocode = new ReverseGeocode($oDB);
+               $oReverseGeocode->setIncludeAddressDetails(true);
+
+               echo "Warm reverse: ";
+               if ($bVerbose) echo "\n";
+               for($i = 0; $i < 1000; $i++) {
+                       $fLat = rand(-9000, 9000) / 100;
+                       $fLon = rand(-18000, 18000) / 100;
+                       if ($bVerbose) echo "$fLat, $fLon = ";
+                       $oReverseGeocode->setLanguagePreference(array('en'));
+                       $oReverseGeocode->setLatLon($fLat, $fLon);
+                       $oReverseGeocode->setZoom(20);
+                       $aDetails = $oReverseGeocode->lookup();
+                       if ($bVerbose) echo $aDetails['langaddress']."\n";
+                       else echo ".";
+               }
+               echo "\n";
+       }
+
+       if (!$aResult['reverse-only']) {
+
+               $oGeocode =& new Geocode($oDB);
+
+               echo "Warm search: ";
+               if ($bVerbose) echo "\n";
+               $sSQL = 'select word from word where word is not null order by search_name_count desc limit 1000';
+               foreach($oDB->getCol($sSQL) as $sWord) {
+                       if ($bVerbose) echo "$sWord = ";
+                       $oGeocode->setLanguagePreference(array('en'));
+                       $oGeocode->setQuery($sWord);
+                       $aSearchResults = $oGeocode->lookup();
+                       if ($bVerbose) echo $aSearchResults[0]['langaddress']."\n";
+                       else echo ".";
+               }
+       }
+