Results 1 to 11 of 11
  1. #1

    Cloud fast enough for small (300.000 records) database?

    I have been trying various cloud trials but because of storage limitations I wasnt able to test and try SQL speed.

    What do you thing about speed of SQL database being within cloud? It is 90% about reading/ 10% about writing and size is somewhere between 100.000 - 400.000 records.

    Opinions? 2GHz, 2GB RAM enough for this environment?

  2. #2
    Join Date
    Apr 2007
    Posts
    3,513
    There are many different ways to implement cloud hosting, which can make them hard to compare.

    SQL is going to be most effected by the Disk I/O speed/performance, so have a look for a host with decent IO performance, RAID10, fast disks and a high number of spindles.
    - Buying up websites, side-projects and companies - PM Me! -

  3. #3
    Join Date
    Nov 2009
    Posts
    544
    It seems that regardless of the "cloud" implementation, most if not all SQL databases are going to be a compromise that will suffer performance and scalability issues on a necessarily dynamic infrastructure.

    Though the answers have yet to be sorted, it seems the answers lie in object oriented and or distributed DBMS's.

    It would not seem prudent to tune or optimize any "cloud" system for SQL at the expense of flexibility and scalability so the recommendation would be to run the OP noted system on legacy hardware.

  4. #4
    Join Date
    Jul 2009
    Location
    Indiana
    Posts
    2,193
    Something you might want to check out - http://aws.amazon.com/rds/
    Sam Barrow - CEO @ SQUIDIX (1-855-SQUIDIX)
    Ask Us About Sponsoring Your Web Site (High Traffic Sites Only)
    Squidix - Shared, Reseller, Semi-Dedicated, Managed VPS and Managed Dedicated Hosting
    Midwestern Web - Web Design & Development Services

  5. #5
    Join Date
    Nov 2009
    Posts
    544
    Quote Originally Posted by SamBarrow View Post
    Something you might want to check out - http://aws.amazon.com/rds/
    Yup, precisely why I added "most". Amazon is working hard on RDS and it may come to be a workable SQL solution but it seems to include several compromises IMO. A quick trip to their forums will note a lot of advancements along with several reasons to keep production systems on legacy hardware.

  6. #6
    Join Date
    Jan 2011
    Location
    Canada
    Posts
    934
    Get as much ram as you can afford. Without going into too much about your queries, you want to avoid paging out your index to disk. Minimum would be the 2GB, but I'd be more comfortable with 8GB.

    Whether you're in the cloud or not is a moot point since your DB isn't big enough. If you were thinking of sharding your sql db, then at that point, I'd worry more.

  7. #7
    Join Date
    Apr 2002
    Location
    Seattle, WA
    Posts
    955
    300k records is nothing, I could run that on my iPhone. What matters more is how you are using your records. What sorts of reads? Properly indexed? Use of joins/unions?
    I <3 Linux Clusters

  8. #8
    Quote Originally Posted by feronovak View Post
    I have been trying various cloud trials but because of storage limitations I wasnt able to test and try SQL speed.

    What do you thing about speed of SQL database being within cloud? It is 90% about reading/ 10% about writing and size is somewhere between 100.000 - 400.000 records.

    Opinions? 2GHz, 2GB RAM enough for this environment?
    you will need to check the IOPS. Most of the cloud provider have limitation on that.

  9. #9
    Join Date
    Sep 2005
    Location
    London
    Posts
    2,404
    buy from a cloudhost that has SSD's or perhaps even FusionIO as a storage option...
    Ditlev Bredahl. CEO,
    OnApp.com & SolusVM.com + Cloud.net & CDN.net

  10. #10
    Join Date
    Jun 2010
    Location
    Los Angeles
    Posts
    26
    Cloud should be fine for you. Like the above poster said, I'd worry more about how properly you've indexed and structured your database+queries.

    Having said that, EC2 is a lot slower than Rackspace when it comes to disk i/o. Switching from EC2 to Rackspace can give you an immediate boost.

    But still, nothing beats a SAS or SSD based web host when it comes to sheer performance, they are about a magnitude faster.

  11. #11
    Check out clouds that specialise in high performance, low latency IO and SAN.
    ____________________________________________
    European and USA IAAS Cloud Hosting
    http://www.dediserve.com Dublin, London, Dallas
    Ranked by Cloudharmony.com as the fastest cloud in the world.

Similar Threads

  1. Database by Design, LLC - Private Cloud Configurator - Build Your Own Cloud Today
    By DatabaseByDesignLLC in forum Cloud Hosting Offers
    Replies: 0
    Last Post: 08-10-2010, 02:35 PM
  2. MySQL Database growing - 100,000 records a day!!
    By W3Solutions in forum Programming Discussion
    Replies: 5
    Last Post: 06-18-2007, 02:56 AM
  3. US Zip Code Database--Over 70,000 Records
    By sawz in forum Other Offers & Requests
    Replies: 0
    Last Post: 03-31-2007, 01:09 PM
  4. Restaurant Database with 291,000 records
    By labrocca in forum Other Offers & Requests
    Replies: 16
    Last Post: 08-16-2005, 04:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •