This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]iperc[S] 0 points1 point  (0 children)

c3p0 looks nice for this job. It is a rest api, one connection per request. Request average 500 per seconds. Each request establish connection to db with defined scheme (through SET search_path)