0
votes
1answer
230 views

Would it be okay to run Apache on one EC2 instance and MYQSL on another?

I'm currently running a VPS that uses ~1.5GB of ram. I'm thinking of switch to Amazon EC2, because access to our host is pretty slow, lots of downtime, etc. An EC2 small instance has 1.7GB, so I ...
2
votes
3answers
853 views

How can I speed up SQL Server queries on Amazon EC2?

Our SQL queries sometimes take too long. We have a Windows Server 2003/SQL Server 2005 setup. We have already created indexes everywhere that's possible. Can we get quicker disks? Any ideas from ...
1
vote
2answers
155 views

What kind of database server should I use for a 500k stored procedure calls per day database?

I have a database that gets about 500,000 stored procedure calls a day in addition to other stuff. It's running too slow for us and we're going to upgrade it when we get around to it. I'm looking at ...