Message-ID: <43BE78BE.3070508@laliluna.de>
Date: Fri, 06 Jan 2006 15:03:42 +0100
From: Sebastian Hennebrueder <usenet@laliluna.de>
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: effizient query with jdbc
References: <20051215080714.03919654@malmo.geotask.ch>
In-Reply-To: <20051215080714.03919654@malmo.geotask.ch>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

You could issue one query containing a
select uuid FROM MDM.KEYWORDS_INFO WHERE KEYWORDS_ID in (xy)
where xy is a large comma separated list of your values.

Best Regards / Viele Grüße

Sebastian Hennebrueder

-----

http://www.laliluna.de

* Tutorials for JSP, JavaServer Faces, Struts, Hibernate and EJB
* Seminars and Education at reasonable prices
* Get professional support and consulting for these technologies


Johannes Bühler schrieb:

> Hi, 
> I have a java.util.List of values (10000) which i wanted to use for a
> query in the where clause of an simple select statement. iterating
> over the list and and use an prepared Statement is quite slow. Is
> there a more efficient way to execute such a query.  Thanks for any
> help.  Johannes 
> ..... 
> List ids = new ArrayList(); 
> 
> .... List is filled with 10000 values ...
> 
> List uuids = new ArrayList(); 
> PreparedStatement pstat = db.prepareStatement("SELECT UUID FROM
> MDM.KEYWORDS_INFO WHERE KEYWORDS_ID = ?");  for (Iterator iter =
> ids.iterator(); iter.hasNext();) { String id = (String) iter.next();
> pstat.setString(1, id);
> rs = pstat.executeQuery();
> if (rs.next()) {
> uuids.add(rs.getString(1));
> }
> rs.close();
> } 
> ... 
> 
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faq
>
>
>  
>