> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:geotools-devel- > [EMAIL PROTECTED] On Behalf Of Chris Holmes > Sent: Thursday, August 16, 2007 7:00 PM > To: Vitali Diatchkov > Cc: 'Jody Garnett'; [EMAIL PROTECTED]; 'geotools-devel' > Subject: Re: [Geotools-devel] AbstractJDBCDataStore and its pilot > implementation for Oracle Spatial > > Do you have performance benchmark numbers vs. the old datastore? It > sounds like really great work, but I'd like to be sure that there's a > clear win to switching to the new one, since I'm sure there will be some > pain if it becomes the new default (lots of minor bugs will likely need > to be fixed). If it's much faster I think we could consider making it > an optional download for GeoServer, which would likely get some more > users testing it. > > best regards, > > Chris >
Performance benchmark is necessary thing. If to concern things that are new here in comparison to what I have seen in old OracleDataStore module: New Oracle Spatial datastore implementation is based on prepared statements where geometries are handled as STRUCT objects. The latter takes away lot of constraints for geometries processing. In all kinds of SQL queries (SELECT, UPDATE, INSERT ) geometry objects are passed as prepared objects. It is impossible to pass to Oracle a geometry with 5000 vertices, e.g., encoded into text-based SQL... We should not be in hurry with making this stuff as a default one. I am able to spend time and get this to the shape based on community decisions and proposals. So next step: I will split JDBC and Oracle code into unsupported GeoTools module. One of the main issues right now is how to determine CRS of geometry attribute types from Oracle in a general way. What is kept in Oracle metadata tables is far from standard WKT CRS represention. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Geotools-devel mailing list Geotools-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
