1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Need a GREAT host that can handle high DB queries...

Discussion in 'Site & Server Administration' started by gweb, Aug 17, 2007.

  1. #1
    Hi all,

    I need a tip; MY SITE is with StartLogic on a shared server - great specs though.. see here - my issue is that my site KEEPS GOING DOWN - and I get furious emails from my visitors!

    When the site fails - it simply says - cannot load, database error - now StartLogic say my site is failng due to one thing and one thing only; and that's high volume DB queries - but I tell them my site is quite new and has low traffic, so how can this be!

    I am very frustrated and I need a cheap dedicated sever or a flaming good shared - any help much appreciated - what shall I do here, do I trust what they're telling me!???

    :(
     
    gweb, Aug 17, 2007 IP
  2. Xavier_3D

    Xavier_3D Well-Known Member

    Messages:
    1,299
    Likes Received:
    25
    Best Answers:
    0
    Trophy Points:
    140
    #2
    Xavier_3D, Aug 17, 2007 IP
  3. tamilsoft

    tamilsoft Banned

    Messages:
    1,155
    Likes Received:
    78
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I think siteground would be ....
     
    tamilsoft, Aug 17, 2007 IP
  4. mamina

    mamina Active Member

    Messages:
    316
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #4
    We have huge amounts of traffic (so much we went to a dedicated server). I would recommend
    http://www.hostned.com

    They have treated me very well with very little downtime.

    According to Pingdom my uptime is 99.98%.
     
    mamina, Aug 17, 2007 IP
  5. gweb

    gweb Well-Known Member

    Messages:
    1,167
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    130
    #5
    How much do u pay for that?
     
    gweb, Aug 17, 2007 IP
  6. M5love

    M5love Well-Known Member

    Messages:
    1,211
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    180
    #6
    Your running forums and arcade ;). Check Asmallorange.com
     
    M5love, Aug 17, 2007 IP
  7. Kuldeep1952

    Kuldeep1952 Active Member

    Messages:
    290
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    60
    #7
    Your current host seems to be providing you 3000 GB Bandwidth for USD 5.95 /month. This seems to be on the higher side. I have 2 VPS with different hosts, and I get a Bandwidth of 120-200 GB for USD 40-50 month. I use only a fraction of it though. If you are facing DB problem, you need to move upto either VDS or VPS or dedicated.
     
    Kuldeep1952, Aug 18, 2007 IP
    gweb likes this.
  8. gweb

    gweb Well-Known Member

    Messages:
    1,167
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    130
    #8
    Thanks everyone! Thats helpful - I do think I am nearing a move to a dedicated server - just a shock cos Im used to paying 5 bux a month! LOL
     
    gweb, Aug 18, 2007 IP
  9. Nitin Gupta

    Nitin Gupta Peon

    Messages:
    445
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #9
    What are your requirements like?? may be i can help you with it.
     
    Nitin Gupta, Aug 18, 2007 IP
  10. gweb

    gweb Well-Known Member

    Messages:
    1,167
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    130
    #10
    I simply need a sever that can handle massive amounts of DB queries - that's it really - the place Im with now already has great Bandwidth and space, so its purely the DB problem...
     
    gweb, Aug 18, 2007 IP
  11. Nitin Gupta

    Nitin Gupta Peon

    Messages:
    445
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #11
    How much is your current monthly usage of space and bandwidth??

    how much is your budget like ?
     
    Nitin Gupta, Aug 18, 2007 IP
  12. gweb

    gweb Well-Known Member

    Messages:
    1,167
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    130
    #12
    at the moment less than 20 gig a month but the site is really expanding quickly so need more! Budget is cheap as possible! LOL - less than $40 / $50 pm
     
    gweb, Aug 18, 2007 IP
  13. Nitin Gupta

    Nitin Gupta Peon

    Messages:
    445
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #13
    Nitin Gupta, Aug 18, 2007 IP
  14. gweb

    gweb Well-Known Member

    Messages:
    1,167
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    130
    #14
    OK, Ill check that out!!!!!!!!
     
    gweb, Aug 18, 2007 IP
  15. Nitin Gupta

    Nitin Gupta Peon

    Messages:
    445
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #15
    I forgot to mention 30 Days Money Back guarantee...
     
    Nitin Gupta, Aug 18, 2007 IP
  16. harrysmith

    harrysmith Well-Known Member

    Messages:
    466
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    110
    #16
    You can try semidedicated server from webhosting.uk.com for £24.99 /Month their support is excellent and are more reliable host for me :)
     
    harrysmith, Aug 18, 2007 IP
  17. ilxeon

    ilxeon Peon

    Messages:
    336
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #17
    bandwidth and Storage are never a problem but CPU resources are, after checking your site it looks the problem is from their end as your site is executing queries very slowly.
    It might also be an issue with some mods you have installed, i would suggest test some other provider before spending money on dedicated solutions.
     
    ilxeon, Aug 19, 2007 IP
  18. gweb

    gweb Well-Known Member

    Messages:
    1,167
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    130
    #18
    HMMMM interesting.. thanks for your help...

    Out of interest, when you say that the site is executing queries very slowly - how do you know that?? And how would I fix it - someone suggested cacheing some DB queries..?
     
    gweb, Aug 19, 2007 IP
  19. ilxeon

    ilxeon Peon

    Messages:
    336
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #19
    your site was loading very slow, now i have checked forum(before it was giving database error) and its showing 70 users online :eek:
    you should consider upgrading to VPS or dedicated, Shared host have maximum concurrent database connections limit thats why you are getting those errors.
     
    ilxeon, Aug 19, 2007 IP
    gweb likes this.
  20. gweb

    gweb Well-Known Member

    Messages:
    1,167
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    130
    #20
    You're right! I will be moving to a dedicated within the next week - its insane - the site is nearly always down :(
     
    gweb, Aug 19, 2007 IP
    ilxeon likes this.