Re: [PERFORM] performance libpq vs JDBC

2010-12-16 Thread Werner Scholtes
l-performance-ow...@postgresql.org [mailto:pgsql-performance- > ow...@postgresql.org] Im Auftrag von Richard Huxton > Gesendet: Donnerstag, 16. Dezember 2010 13:15 > An: Werner Scholtes > Cc: Divakar Singh; pgsql-performance@postgresql.org > Betreff: Re: [PERFORM] performance libpq vs JDBC

Re: [PERFORM] performance libpq vs JDBC

2010-12-16 Thread Werner Scholtes
: Donnerstag, 16. Dezember 2010 10:38 An: Werner Scholtes; pgsql-performance@postgresql.org Betreff: Re: [PERFORM] performance libpq vs JDBC If you have all records before issuing Insert, you can do it like: insert into xxx values (a,b,c), (d,e,f), ..; an example: http://kaiv.wordpress.com

Re: [PERFORM] performance libpq vs JDBC

2010-12-16 Thread Werner Scholtes
11 An: Werner Scholtes; pgsql-performance@postgresql.org Betreff: Re: [PERFORM] performance libpq vs JDBC Can you trying writing libpq program using COPY functions? I hope it will be better than prepared statements. Best Regards, Divakar From: Werner Scholtes To: &

[PERFORM] performance libpq vs JDBC

2010-12-15 Thread Werner Scholtes
no chance to use COPY statements)? I didn't find anything comparable to PreparedStatement.executeBatch() in libpq. Best regards, Werner Scholtes