| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Jasper Potts <jasper(at)jasperpotts(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Select where id in (LARGE LIST) ? |
| Date: | 2005-07-29 23:17:37 |
| Message-ID: | 42EAB911.9030700@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Jasper Potts wrote:
> The best solution I have so far is to create a selection table and write
> the select out to that and perform a join but the 100,000 inserts are slow.
How are you constructing this table? If you use batched inserts with
autocommit off, it should be fairly fast; I get 8000+ inserts per second
over larger data sets.
Can you move the selection list into the DB semi-permanently? Really,
the underlying problem is that you need to move a 100,000-item list to
the database on every SELECT.. if you can have the list "already there"
it's going to be faster.
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oliver Jowett | 2005-08-01 07:02:36 | Timestamp changes committed to HEAD |
| Previous Message | Jasper Potts | 2005-07-29 19:18:51 | Re: Select where id in (LARGE LIST) ? |