Query precompilation?
От | Steffen Emil Thorkildsen |
---|---|
Тема | Query precompilation? |
Дата | |
Msg-id | Pine.SOL.4.21.0102271323460.3437-100000@fjorir.ifi.uio.no обсуждение исходный текст |
Ответы |
Re: Query precompilation?
Re: Query precompilation? |
Список | pgsql-hackers |
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 me. 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! 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 по дате отправления: