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