Hello,
I'm using GN 2.6.4 with a MySQL database, but having trouble with enabling
the spatial indexing.
Would anyone know the exact command to create spatial index for GN database
in MySQL?
Thank you,
André.
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/MySQL-and-spatial-index-tp5007699.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.
Hi
Afaik, in 2.6.4 spatial index is only enabled for PostGIS not in MySQL.
In trunk/2.8.x Oracle is also supported, but not sure if MySQL.
Regards,
Jose García
On Wed, Oct 10, 2012 at 2:51 PM, apontes <apontes@anonymised.com> wrote:
Hello,
I'm using GN 2.6.4 with a MySQL database, but having trouble with enabling
the spatial indexing.Would anyone know the exact command to create spatial index for GN database
in MySQL?Thank you,
André.--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/MySQL-and-spatial-index-tp5007699.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
--
*
GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on
GeoServer and GeoNetwork. Visit http://geocat.net for details.
_________________________
Jose García
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net/>
*
Afaik, in 2.6.4 spatial index is only enabled for PostGIS not in MySQL.
Really?
I thought I had read that I had to create the spatialIndex table manually
(which I did) and GN would use it normally, but I can't seem to locate my
source right now.
I'll keep looking and post my source if I manage to find it.
Thanks for the fast reply,
André
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/MySQL-and-spatial-index-tp5007699p5007720.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.
Hi
Maybe is possible to use it, but at least the sql scripts and example
database config to store spatial index in database are only related to
PostGIS in 2.6.X.
Probably other people can provide more feedback on this to clarify if
possible to use MySQL for spatial index?
Regards,
Jose García
On Wed, Oct 10, 2012 at 3:32 PM, apontes <apontes@anonymised.com> wrote:
> Afaik, in 2.6.4 spatial index is only enabled for PostGIS not in MySQL.
Really?
I thought I had read that I had to create the spatialIndex table manually
(which I did) and GN would use it normally, but I can't seem to locate my
source right now.I'll keep looking and post my source if I manage to find it.
Thanks for the fast reply,
André--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/MySQL-and-spatial-index-tp5007699p5007720.html
Sent from the GeoNetwork users mailing list archive at Nabble.com.------------------------------------------------------------------------------
Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at
http://sourceforge.net/projects/geonetwork
--
*
GeoCat Bridge for ArcGIS allows instant publishing of data and metadata on
GeoServer and GeoNetwork. Visit http://geocat.net for details.
_________________________
Jose García
GeoCat bv
Veenderweg 13
6721 WD Bennekom
The Netherlands
http://GeoCat.net/>
*