[mapserver-users] RE: MySQL data

[Lime, Steve D (DNR)]

Hi Kent: Probably need more information regarding:

  - versions
  - access method (are you using GDAL?)
  - what type of spatial data (MySQL geometries vs points in x/y columns)
  - etc...

Steve
________________________________________
From: mapserver-users-bounces at lists.osgeo.org [mapserver-users-bounces at lists.osgeo.org] On Behalf Of Kent Morrison [KMorrison at advantrack.com]
Sent: Thursday, June 17, 2010 2:13 PM
To: 'mapserver-users at lists.osgeo.org'
Subject: [mapserver-users] MySQL data

I have data stored in MySQL. When I configure the map file to pull from a small subset of the data, tiles are generated correctly. If I change the map file to point to the larger master table, map server returns "CGI Timeout". I dont't really want to breakdown the master data table into hundreds of smaller tables. I need additional informaiton and/or suggestions on how to get mapserver to work with millions of rows of data in MySQL.

Kent W. Morrison
Software Development Manager
Advanced Tracking Technologies, Inc.
6001 Savoy, Suite 600, Houston Texas 77036
(W) 713-353-6065 (C) 832-434-8175
<mailto:kmorrison at advantrack.com>