Pconnect vs Connect when having 50K users

Forum Moderators: open

Message Too Old, No Replies

Pconnect vs Connect when having 50K users

asantos

5:02 pm on Jul 3, 2009 (gmt 0)

Hi, i have 50K active users on a mobile service. The java app connects to the database through an API.

Im currently using a normal connection, but it gets a little crowded sometimes.

Should i change it to Pconnect (persistant connection) and what are the benefits of this when having so much users connecting to the DB?

Thanks,
Andres

asantos

4:33 pm on Jul 7, 2009 (gmt 0)

any thoughs on this matter?

jmccormac

5:41 am on Jul 11, 2009 (gmt 0)

Theoretically, a persistent connection gets reused so it does not waste time and resources setting up and tearing down connections. The critical aspect is how many queries/sessions per second are being processed. You should also look at optimising the database connections and configuration.

Regards...jmcc