lundi 9 mars 2015

AWS can't retrieve files from my remote SQL Server database

I've got the exact same project running on two different hosts. One version on Arvixe, the other on AWS. The database that holds my file data is located on Arvixe. The AWS version looks at the Arvixe DB. So I've got two identical projects looking at the same database.


On Arvixe, everything works great. The download method is simply getting a row with file data, based on an ID, and returning the File. Quick and easy.


On AWS, I know the database is connected (I get all my blog posts, account info, etc), but when retrieving a row of data, it just loads forever. I have tried upgrading my instance type to something fairly powerful and expensive, to no avail. I don't think it needs to be that powerful, it's only searching 1200 rows with maybe 1.2 gigs in data. It takes so long that I can't even get to an error message. I know I should likely upgrade the code to take advantage of S3, but I'd like it to be able to work with the DB for now.


Any ideas? This has me stumped.





Aucun commentaire:

Enregistrer un commentaire