-
Which to use Shared Server or Connection Pooling?
Hi,
I need to upscale our system to support more users / applications. We are using dedicated server. I have 150+ connections now and need to add 150 more. I see that I have 2 options:
1. Oracle Shared Server.
2. 2nd level tier connection pool (some software solution I have not decided upon yet).
My question which solution would you recommend?
Typically my users /apps run queries < 10 secs but sometimes the SAME users will run a 30-60 second query.
Sharer Server looks like a good 'free' option as I use Oracle 10g EE. But perhaps not the best solution.? Any advice would be helpful.
Thanks!
Steve.
-
or leave it as dedicated. Shared server isnt too popular anymore for some reason - there is a performance penalty with it.
I would suggsty a connection pool in your app server with dedicated processed. 300 connections isnt really a lot and you are going to save yourself a lot on connection times if you do that
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|