Enable/Disable spatial indexing in Autodesk FDO Provider for Oracle

[Ray]

Each time when I create a feature class with GeometricPropertyDefinition, spatial indexing is automatically enabled. I wonder if there is a way that let me enable/disable the spatial indexing.

I need to import a lare dataset using FDO. I wonder if I could disable the spatial indexing during import but enable it after import so that it could speed up the import process.

I am using Autodesk FDO provider for Oracle.

Thanks,
Ray

[Dan Stoica]

I didn't check but I'm pretty sure it is not possible.

How did you reach the conclusion that the spatial indexing is the culprit for slow performance? Insert/update are slow operations anyways. This said and assuming we disable the spatial index, in the end it may not make a significant difference.  

Dan.

 

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Ray
Sent: Monday, February 21, 2011 10:53 AM
To: [hidden email]
Subject: [fdo-users] Enable/Disable spatial indexing in Autodesk FDO Provider for Oracle


Each time when I create a feature class with GeometricPropertyDefinition,
spatial indexing is automatically enabled. I wonder if there is a way that
let me enable/disable the spatial indexing.

I need to import a lare dataset using FDO. I wonder if I could disable the
spatial indexing during import but enable it after import so that it could
speed up the import process.

I am using Autodesk FDO provider for Oracle.

Thanks,
Ray
--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Enable-Disable-spatial-indexing-in-Autodesk-FDO-Provider-for-Oracle-tp6049141p6049141.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users

[Greg Boone]

Can't you disable the index using Oracle tools and recreate it using the same tools after the import is complete?

Greg

-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of Ray
Sent: Monday, February 21, 2011 10:53 AM
To: [hidden email]
Subject: [fdo-users] Enable/Disable spatial indexing in Autodesk FDO Provider for Oracle


Each time when I create a feature class with GeometricPropertyDefinition, spatial indexing is automatically enabled. I wonder if there is a way that let me enable/disable the spatial indexing.

I need to import a lare dataset using FDO. I wonder if I could disable the spatial indexing during import but enable it after import so that it could speed up the import process.

I am using Autodesk FDO provider for Oracle.

Thanks,
Ray
--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Enable-Disable-spatial-indexing-in-Autodesk-FDO-Provider-for-Oracle-tp6049141p6049141.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/fdo-users