[mapserver-users] WFS Layer running OGR Query Multiple times per request

[Frank Warmerdam]

joncoign wrote:
> I have a WFS layer that is querying the database via an OGR ODBC connection
> once per point included in the result set plus one additional query. I was
> under the impression that this should only execute once. Am I
> misunderstanding or do I have something misconfigured? Map file and SQL
> Profiler output below.

Jon,

Your profiling is correct.  The MapServer query mechanism as it exists in
5.4 (and since the beginning of time) results in many small queries against
OGR, and other database backends. It is for exactly this reason that Steve
is re-engineering the query mechanism for 6.0 to do "single pass query".

The situation should improve substantially in 6.0.

I would note this problem with many small queries applies only to the
query mechanism, not map drawing which just does one query per layer draw.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent