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
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"]);
$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. *************************************************************************
