Skip site navigation (1) Skip section navigation (2)

strange problem

From: "Gilbert, Antoine" <AGilbert(at)korem(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: strange problem
Date: 2006-01-25 19:51:24
Message-ID: DF58692A2DBF5440910BFE80B73D73E1019F2A4E@sqexc02.korem.local (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi

 

I have a single PostGIS table in PostgreSQL

 

This table has 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. 

 

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2006-01-25 20:20:32
Subject: Re: strange problem
Previous:From: David HustaceDate: 2006-01-25 19:23:01
Subject: Re: Socket read fails

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group