MySQL and mapfile

[Jeff Portwine]

You don't happen to have a link to that post about .qix files do you?   I
have no idea what they are about, but I know that most of my shapefiles
don't have them.   If I can create them and speed up my application I'd love
to do so :)

-Jeff

----- Original Message -----
From: "Don Deskins" <dldeskins at GMAIL.COM>
To: <MAPSERVER-USERS at LISTS.UMN.EDU>
Sent: Tuesday, April 05, 2005 2:23 PM
Subject: Re: [UMN_MAPSERVER-USERS] MySQL and mapfile


> Steve,
>
> Thank you very much for your reply.  I am sorry to say that I didn't
> know there was a ".qix" file.  With my database background, I assumed
> that an indexed database field would be faster than a flat file.  Of
> course, that is correct if the flat file is not index.  I searched
> through the archives and found out what a .qix file was all about. I
> created one for each of my shapes and sped up download time by 50%.
> Now on to tiling the shp files :)
>
>
> Thanks again
>
> On Apr 5, 2005 12:11 PM, Stephen Woodbridge <woodbri at swoodbridge.com>
> wrote:
>> Don Deskins wrote:
>> > Hello,
>> >
>> > Again, I am new to mapserver.  I have finally gotten my map to display
>> > properly but it is very slow, so I am interested in getting all of the
>> > data
>> > into a database (MySQL).
>>
>> Shapefiles are very fast if they are set up correctly and indexed. You
>> would be wise to understand and resolve the performance issues before
>> moving the data to mysql as it is not likely to be faster.
>>
>> For example do all you shapefiles have *.qix file?
>> How is your mapfile structured? Are you trying to draw too much detail
>> at larger zoom values?
>>
>> When is it slow? Zoomed in or zoomed out or both. If we had some more
>> information we might be able to help you resolve the performance issues.
>>
>> Understanding these issues might also help you when you get the data
>> loaded into mygis.
>>
>> -Steve W.
>>
>> > I have data (in .shp, .dbf, and .shx files) that I have converted using
>> > mygisimport.  This produce an sql file which I imported into the MySql
>> > db.
>> > I am now having trouble accessing this data with the mapfile.  Here is
>> > what
>> > I have:
>> >
>> >   LAYER
>> >     NAME "SCAP_Cert2004_ParcelsUTM16M"
>> >     CONNECTIONTYPE mygis
>> >     CONNECTION "host:user:password:db:bin:"
>> >     #geo is the name of the column
>> >     DATA "geo from Parcels feature"
>> >     STATUS ON
>> >     TYPE POLYGON
>> >     CLASS
>> >       OUTLINECOLOR 255 0 0
>> >       TEMPLATE "template.html"
>> >     END
>> >     MAXSCALE 40000
>> >     TOLERANCE 0
>> >     TOLERANCEUNITS PIXELS
>> >   END
>> >
>> > I get the following error:
>> >
>> > Warning: [MapServer Error]: SELECT feature.id, feature.vertices,
>> > geometry.WKB_GEOMETRY from bad mysql query : bad mysql query in
>> > <filepath
>> > and name> on line 217
>> >
>> > Can anyone help with this?
>> >
>> > BTW, I tried to use shp2mysql.pl, but got several failures.
>> >
>> > Thanks,
>> >
>> > Don
>> >
>>
>>
>
>
> --
> Don Deskins
>