jdbc batch performance problem
| От | pginfo |
|---|---|
| Тема | jdbc batch performance problem |
| Дата | |
| Msg-id | 3F18EA9C.24B78DF2@t1.unisoftbg.com обсуждение исходный текст |
| Ответы |
Re: jdbc batch performance problem
Re: jdbc batch performance problem Re: jdbc batch performance problem |
| Список | pgsql-jdbc |
Hi, I am using pg + jdbc for j2ee development from a long time. The main problem I found is the very bad insert performance. I am using addBatch and executeBatch for minimum network trafik, but it is also very slow. For example if I try to insert 1000 rows ( in one transaction) into very simple table it takes ~ 3000 ms. If i use insert into myTable select ... it takes only 10 ms. Exist any basic performance problem for pg jdbc or I make mistake? Also I testet the same example on oracle 8i and mysql. It is working much much better. I love pg but it will be great if I can make insert faster. Many thanks, ivan.
В списке pgsql-jdbc по дате отправления: