![]() |
|
|
|
|
Issue Type:
|
![Bug]() Bug
|
|
Affects Versions:
|
9.2 |
|
Assignee:
|
Christian Mueller
|
|
Components:
|
jdbc-db2 plugin |
|
Created:
|
16/Jun/13 4:15 AM
|
|
Description:
|
The official way to calculate an extent is a statement like this.
SELECT ST_GetAggrResult(MAX(ST_BuildMBRAggr
(geometry)))
FROM sample_points
Unfortunately, this performs badly for large data sets. (Tested with 8 million rows containing simple squares --> 90 seconds).
The alternative is
select min(st_minx(geom),min(st_miny(geom),.....
This statement needs only 20 seconds.
Additionally, since DB2 V10 the extent calculation can be done during registering a spatial attribute. (Registering the attribute after populating the table). The fix checks for precalculated extents in the system table before calculating the extent on the fly.
|
|
Project:
|
GeoTools
|
|
Priority:
|
![Major]() Major
|
|
Reporter:
|
Christian Mueller
|
|
|
|
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
