mysql querybyattributes

Skalski Artur - askals Artur.Skalski at ACXIOM.COM
Wed Apr 19 10:17:39 PDT 2006


Can someone point me how to do eficiently querybyattributes on mysql layers using php/mapscript?
 
The layer has over 1 000 000 records (I don't want to split it unless...) can be displayed and queried by point when clicking on map, those things work fast but when it comes to querybyattributes I get error message:
"Execution time of 30 seconds exceded"
 
I know that i can set execution time to 'no limit' but it's no use since user will has to wait that long for each query results.
 
Please help!
 
this is my map file with this problematic layer:
LAYER
     GROUP searchableH
     NAME address
 METADATA
  "DESCRIPTION" "address"
  "RESULT_FIELDS" "ADDRESS"
 END
     TYPE POINT
     CONNECTIONTYPE OGR
     CONNECTION "vdf/address.ovf"
 DATA "address"
     STATUS ON
 PROJECTION
  "init=epsg:4326" #lon/latwgs84
 END
     TEMPLATE "address.html"
     CLASS
         NAME "address"
         STYLE
          SYMBOL 'C:\Inetpub\wwwroot\mapserver\test\etc\pkp.gif'
         END
     END
END
 
and piece of php code that does the query:
 
$qLayer = $gpoMap->GetLayerByName($HTTP_FORM_VARS["SearchedLayer"]);
$qFiled = $HTTP_FORM_VARS["SearchedField"];
$qValue = strtoupper($HTTP_FORM_VARS["SearchedValue"]); 

  $qLayer->queryByAttributes($qFiled, $qValue, MS_MULTIPLE);
 
what can be wrong???
 
Best Regards

Artur 

*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.

If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank you.
*************************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20060419/066564a4/attachment.htm>


More information about the MapServer-users mailing list