Re: Query precompilation?

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.)