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 a
Is there a reason you can't rewrite your SELECT like:
SELECT UUID FROM MDM.KEYWORDS_INFO WHERE KEYWORDS_ID IN (a, b, c, d)
Even doing them 100 at a time will make a big difference; you should
put as many in the list as pgsql supports. I'm assuming that there's
an index over KEYWORDS_ID.
Re
The problem is you are getting the entire list back at once.
You may want to try using a cursor.
Dave
On 15-Dec-05, at 9:44 AM, [EMAIL PROTECTED] wrote:
Hi,
I have a java.util.List of values (1) which i wanted to use for
a query in the where clause of an simple select statement.
iterat
Hi,
I have a java.util.List of values (1) 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
..
Hi,
I have a java.util.List of values (1) 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
...
Hi,
I have a java.util.List of values (1) 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
Hi,
I have a java.util.List of values (1) 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
...
