Re: [GENERAL] Prepared Statements and Pooling

2015-08-11 Thread Alban Hertroys
On 11 August 2015 at 06:44, Mister Junk wrote: > I'm using prepared statements to prevent SQL injection, but I have done some > reading and it seems like using Prepared statements COULD improve > performance. I understand the concept, but I do not know how to implement > this. They could, they c

Re: [GENERAL] Prepared Statements and Pooling

2015-08-11 Thread Andomar
> I have considered opening a single connection to the server and letting all > threads execute statements through it, and use prepared statements (serviced > by postgresql, not JDBC or DBCP). Or simply opening 50 connections and > establishing prepared statements and then handing them off to t

[GENERAL] Prepared Statements and Pooling

2015-08-10 Thread Mister Junk
I'm working on a project for school that requires a simple java server (a ServerSocket creates Socket connections which I send JSON strings over) which then communicates with a database. Obviously I have chosen PostgreSQL. I'm using Apache DBCP for connection pooling. The DataSource is handed of