I am wondering if I can get your advice on how to plan for the future.
Currently, I run SCM on a Virtual Machine, an EC2 via Amazon. It has an Intel Xeon Processor 2.5 Ghz, 4 Gigs of Ram and 30 gig hard drive.
I was happy with the performance, until I started to build up Proxy Accounts with a second Database instance. Even with only 70 Proxy accounts on the second database, performance slowed down to mind numbing speeds. I click a button and wait 8-10 seconds for the click to register.
![Sad :(](./images/smilies/icon_e_sad.gif)
It is my goal to have a healthy roster of approx 1k proxy accounts, along with around 25 normal accounts that I manage. What I am trying to decide is how can I move forward and ensure fast processing and room for growth?
Would the best way be to:
A) Upgrade to a new Virtual Machine that is much faster and with a bigger hard drive and more ram?
B) Divide the accounts over MANY virtual machines and ensure no more than a single database runs at a time.
C) Divide the accounts over FEW virtual machines and *TRY* to run 3 databases per machine (the maximum).
Obviously with more than three installations of SCM, I would need to purchase more licenses. That's totally fine. I'm just concerned about PERFORMANCE. How can I ensure that I can continue to grow and maintain fast speed?
Any help / advice would be GREATLY appreciated!!!
Thank you.