[postgis-users] strange jdbc problem

[Gilbert, Antoine]

Hi

 

I have a single PostGIS table in PostgreSQL

 

This table have like 500000 records

 

I use the JDBC driver to only send a quick query without browsing
resultset and it take forever. For example:

 

Statement stmt = connection.createStatement();

ResultSet rs =stmt.executeQuery("select street from \"QCs_polyline\"");

stmt.close();

 

This takes 19 sec. Does I am missing something like a configuration on
the driver? So far I was just testing PostGIS/PostgreSQL with tiny
tables. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060125/64054d21/attachment.html>