[postgis-users] PERFORMANCE PROBLEMS II (More Data)
alvaro_zabala at hotmail.com
Wed Mar 3 01:14:29 PST 2004
Ive created some statistics with JUMP. My layer(postgis table) has:
Min Max Avg Total
Pts 739 6459 3144.0 185525
Length 112012.87741183324 542055.2324866682 248916.0411825297
We have 739 features, the minimum point number of a feature is 739, maximum
6459 points, and all the features of the table has 185225 points.
Ive been making a little tuning, and using JDBC, with my app and postgis in
the same PC, 512 Mb RAM, P4 1,4 GHz, Windows 2000 with Cygwin, this
DECLARE my_cursor CURSOR for SELECT asText(GEOMETRY) AS
GEOMETRY,C_PV,C_OCA,D_OCA,GID FROM ocas WHERE GEOMETRY && 'BOX3D(88034.16
3926963.056375266, 634143.4400000001 4339164.943624733'::box3d;
FETCH FORWARD ALL IN my_cursor;
runs in an average time of 2200 ms. (2,2 seconds for a table with 700 rows
and an average geometry of 3144 points, 190000 points in total)
Are these times normal? Can I improve my overall performance by tuning?
Add photos to your messages with MSN 8. Get 2 months FREE*.
More information about the postgis-users