Re: Query precompilation?
От | Robert Schrem |
---|---|
Тема | Re: Query precompilation? |
Дата | |
Msg-id | 01022714162500.09116@pc-robert обсуждение исходный текст |
Ответ на | Query precompilation? (Steffen Emil Thorkildsen <steffent@ifi.uio.no>) |
Ответы |
Re: Re: Query precompilation?
|
Список | pgsql-hackers |
On Tue, 27 Feb 2001, you wrote: > Hi, > > I have an application which has an queue of data it has to insert into > a table in a local database. the insert-queries syntax is all the same, > and the values are the only thing that differs. The insert-query looks > like this: > > INSERT INTO "table" VALUES(a, b, c, d, e, f, g, h) > > ...but I cannot insert more than 200/sec, and that is much too slow for > mme. Are there ways to precompile a sqlquery or do other tricks to get the > *fastest* insertion-rate, since the data-queue is growing faster than > 200/sec... > I don't care about integrity etc! You should !-) You can find some valueable tips in the documentation: http://www.de.postgresql.org/users-lounge/docs/7.0/user/c4929.htm > I'm using PostgreSQL 7.0.3, RH 6.2 Linux 2.2.4, and the pq library with > gcc. > > > Regards, > > Steffen E. Thorkildsen > > (PS! Please reply to my e-mail aswell.)
В списке pgsql-hackers по дате отправления: