[postgis-users] PERFORMANCE PROBLEMS II (More Data)

[Alvaro Zabala]

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 
1.4686046429769253E7


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 
sentencie:

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*. 
http://join.msn.com/?page=features/featuredemail