GeoTools is probably just issuing SQL statements to MySQL - you will need to check if those SQL statements speed up if a spatial index is available. For PostGIS the same statement will work for both a table with a spatial index and for a table without one....
GeoTools will not make its own spatial index. Jody On 28/09/2009, at 6:44 PM, iceDice wrote: > > Hi Andrea, > > I know that is possible to use InnoDB tables for spatial data, however > without > support for spatial indexes. > What i want to know is does it make impact on GeoTools renderer. > I mean does renderer uses those spatial indexes from MyISAM tables or > maybe makes own spatial indexes? > > Best regards. > > > aaime wrote: >> >> iceDice ha scritto: >>> Hello, >>> >>> I am interested does GeoTools renderer use spatial indexes from >>> MySQL >>> MyISAM >>> tables when >>> rendering spatial data from MySQL database? >>> I am asking this because we want to use MySQL InnoDB tables both for >>> spatial >>> and non-spatial >>> data. Will GeoTools renderer be slower in this case in contrast if >>> we had >>> used MySQL MyISAM >>> tables for spatial-data? >> >> Last time I checked (almost two years ago) MySQL supported spatial >> data >> in MyISAM tables only. >> Not sure if things changed in the meantime >> >> Cheers >> Andrea >> >> >> -- >> Andrea Aime >> OpenGeo - http://opengeo.org >> Expert service straight from the developers. >> >> ------------------------------------------------------------------------------ >> Come build with us! The BlackBerry® Developer Conference in SF, >> CA >> is the only developer event you need to attend this year. Jumpstart >> your >> developing skills, take BlackBerry mobile applications to market >> and stay >> ahead of the curve. Join us from November 9-12, 2009. Register >> now! >> http://p.sf.net/sfu/devconf >> _______________________________________________ >> Geotools-gt2-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users >> >> > > -- > View this message in context: > http://n2.nabble.com/GeoTools-MySQL-tp3728017p3728255.html > Sent from the geotools-gt2-users mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Come build with us! The BlackBerry® Developer Conference in SF, CA > is the only developer event you need to attend this year. Jumpstart > your > developing skills, take BlackBerry mobile applications to market and > stay > ahead of the curve. Join us from November 9-12, 2009. Register > now! > http://p.sf.net/sfu/devconf > _______________________________________________ > Geotools-gt2-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
