Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking into setting up a database in Amazon RDS for use with Crystal Reports. Crystal will be running in our office in California and the DB will reside in the Amazon cloud servers in Virginia. Is this advisable or should Crystal and the DB reside on the same LAN?

I have no experience with Crystal, so I don't know how data-intensive the connection with the DB is. I have used Aqua Data Studio and even SQL Server Manager from my box in California to run queries and perform operations on a SQL Server 2008 db hosted by Rackspace in Dallas. Performance was surprisingly good.

share|improve this question

closed as not constructive by Ƭᴇcʜιᴇ007, Tog, bwDraco, Brad Patton, Scott Apr 21 '13 at 0:05

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

How do you know the DB is in VA? With Amazon Cloud it could be at any of their datacenters, no? I think the only way to know for sure about the performance would be to test it. – Brad Patton Apr 19 '13 at 17:23
Amazon gives you a lot of control. I can specify the region when creating the DB server. I am in the process of coordinating a test with my users, but they're scattered all over. I'm hoping for feedback from people who have walked this road before. – Brien Malone Apr 19 '13 at 17:28

As long as you follow recommend guidelines for creating your reports data source it should work fine for you. Crystal has some idiosyncrasies (like cross-joining top level data entities if more than one is defined, or the way queries in subreports are executed), but in the end, its not all that differant from your interactive query engine from a performance perspective.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.