<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-2">
<META content="MSHTML 6.00.2800.1543" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>Hi
All</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>not so long ago I
was asking for some advice regarding queryByAttributes on large datasets (1 000
000 records). Thanks againf for all tips!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>I finaly decided to
export data to mysql, and now I'm facing another problem concerning doing
queryByAttributes on the 1000000 record layer.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>I try to do it as
simple as possible, using phpmapscript:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>the code is
like:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006>@$qLayer->queryByAttributes($qFiled, $qValue,
MS_MULTIPLE);</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>it works well on
smaler mysql tables as well as on TAB's and SHP files</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>BUT
</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>when I do qery on
this largest table i can see in the Task Manager that at first mysql proces
starts and it is working for a while but then it dies and php-cgi proces goes
for 99% of the CPU usage the it dies too, and no results are
returned.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>When I do this
query/selection usig just SQL in phpMyAdmin i can get the query result very
fast, like 2 seconds.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>I can display the
largest mysql table on the map, I can query it using queryBypoint and it gives
me good resluts, but somehow querybyattributes gives no results -
WHY?!!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>I'm using mapserver
4.6 with php/mapscipt 4.6, php is as php-cgi, and it runs on
IIS.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>Can someone please
help?!!!</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>What can be the
cause of this?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=562574313-19042006>Best
Regards</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=562574313-19042006></SPAN></FONT> </DIV>
<P><FONT face="Arial CE" size=2>Artur</FONT></P><pre>*************************************************************************
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.
*************************************************************************
</pre></BODY></HTML>