Re: Prepared Statements
От | Csaba Nagy |
---|---|
Тема | Re: Prepared Statements |
Дата | |
Msg-id | 1058543361.25132.314.camel@coppola.ecircle.de обсуждение исходный текст |
Ответ на | Re: Prepared Statements (Dmitry Tkach <dmitry@openratings.com>) |
Список | pgsql-jdbc |
That's a hack indeed, but there's no finger crossing :-) We do chunk our queries if needed, i.e. execute them multiple times if the parameter set is too big. We mostly use this technique to filter a set according to some criteria. Now if the set is too big, we do the filtering chunk-wise, and then cumulate the result. I admit that it won't work for all situations, but then if you have a big set, you might be looking for a different solution like dumping them in to a temporary table. Cheers, Csaba. > Some people are used to hacks, like one described in an earlier post - > where yuo create a statement with an awful lot of questionmarks, and > then set each member of the set separately and cross your fingers, > hoping that you have enough placeholders for your whole set... > > Dima > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >
В списке pgsql-jdbc по дате отправления: