Jody Garnett ha scritto: > Andrea Aime wrote: >> I hope the api is all I need, and it still works with Oracle 10g. If >> so, it may fix the big performance problem I noticed, with the profiler, >> in the actual STRUCT parsing (the driver is so silly that it first >> builds a string representation of the coordinates and then parses them >> into numbers, I let you imagine how slow this can be). > Gak! So all that work we do to set up prepaired statements is for nothing?
I cannot be sure, I profiled only reading and ps are used only for writing but... probably. The thing really is, ps per se won't give you much speed boost: if you want a speed up, you have to prepare the statement once, set the parameters, call addBatch(), and go on, so that you can cut the number of network round trips by 10 or 100. That's what gives you the real speedup write wise. Read wise, on the contrary, it's about efficiently transferring and parsing the geometry, what's the best way, I don't know. For example, for 2D geometries Oracle now supports WKB, that's certainly interesting, I'll have to compare it with JGeometry, if it gives a significant benefit JGeometry could be used for 3d geoms only (afaik wkb as defined by ogc is stuck to x,y coordinates, right?) Cheers Andrea ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
