Have you checked that the spatial index used by Oracle is well fitted? (Try Oracles Spatial Advisor to get a guess for the parameters).
Christof > Hi > We r also seriously working on Oracle Spatial with MapInfo product > range, and would like to add some comments to the ongoing discussion. > I'm having two databases SQL server 7.0 (with Spatialware4.5 trial > version) > and Oracle8i spatial > > Both my databases are populated with a set of 23 layers, populated > through > EasyLoader. > Now when I load a Workspace with "Live Access" in MI 6.5, the > SQL-Spatialware loads the workspace in less than 50 sec and it takes > about > 170 sec for the Oracle spatial database to load the same workspace.. > > Any comments on this observation..?? > Is it something to do about Spatialware being native to MapInfo and the > way > Oracle stores spatial data..?? > > Regards > Kaul, Deepak > Software Engineer > RMSI, NOIDA > INDIA > > > > _______________________________________________________________________ > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, send e-mail to [EMAIL PROTECTED] and > put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
