Changeset 57336

Timestamp:

03/07/08 15:51:56 (2 months ago)

Author:

ischommer

Message:

upped max_allowed_packet sizes for mysql when importing/displaying shape data

Location:

modules/marketdemandmap/trunk/code/controller

Files:

• DemandMap.php (modified) (1 diff)
• SupplyImporter.php (modified) (2 diffs)

modules/marketdemandmap/trunk/code/controller/DemandMap.php

@@ -71 +71 @@
                 parent::init();
                 
+                // set max_allowed_packet to 32MB to allow for large binary imports
+                DB::query('SET GLOBAL max_allowed_packet=32*1024*1024;');
+                
                 if(empty(DemandMap::$google_api_key)) user_error('Please provide a Google Maps API Key', E_USER_ERROR);
                 

modules/marketdemandmap/trunk/code/controller/SupplyImporter.php

@@ -87 +87 @@
          */
         function doUpload($data, $form) {
-                set_time_limit(360);
+                // 10 minutes and 700MB or PHP memory should be enough...
+                set_time_limit(60*10);
                 ini_set('memory_limit', '700M');
-                
+
+                // set max_allowed_packet to 32MB to allow for large binary imports
+                DB::query('SET GLOBAL max_allowed_packet=32*1024*1024;');
+
                 $fileSHP = new File();
                 $fileSHP->loadUploaded($_FILES['_ShapeFileSHP'], $this->tmpFolder);
@@ -133 +137 @@
                 $updateCount = 0;
                 $ignoredCount = 0;
-                
+
                 for($RECID=0; $RECID < $shp->dbf->dbf_num_rec; $RECID++) {
                         // HACK 2008-06-18 by Ingo Schommer: always use first array element