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)

10+ Year Member



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)

10+ Year Member



any thoughs on this matter?

jmccormac

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

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



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