#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Posts
    7
    Rep Power
    0
    Okay, most of my site's content is automatically generated from a couple mySQL queries each time someone loads the page. Does this put a lot of strain on the server?

    Would it help if I had it generate the data into a text file each time I modify the database? So, each time it loads it just loads up the text file instead of querying the database.

    ------------------
    sonic junkie
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    2
    Rep Power
    0
    it depends on how much visitors you're expecting. i'm running a site with about 2500 unique visitors a day (200000 file requests a day) and every single page is generated with 5-25 queries. we're on a virtual server with i think 50 others sites, the pages load fast and we haven't got any complaints about server load or database usage from our provider.
    so i guess it won't be any problem

    [This message has been edited by snq (edited October 25, 2000).]
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Posts
    7
    Rep Power
    0
    Okay thanks. My site doesn't get anywhere near that much traffic. But it's helpful to know that I can use several queries on each page without worries.

    ------------------
    sonic junkie
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    1
    Rep Power
    0
    That's interesting snq because I'm running a site with similar stats (though a bit higher) and it slows to a crawl during peak times but blazes in offtimes.

    We're running off a server farm with a few others sites so I'm not sure what could be the problem.
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    2
    Rep Power
    0
    omen,
    our provider has a dedicated mysql server, so the server load is kind of split, maybe that might be it? the last couple of days there's a noticable delay (like maybe one sec) in every page tho, but that's probably because they host almost 30000 domains in total -> they need an extra mysql server
    we're thinking of getting our own dedicated server tho, since we have almost 40gig traffic/month now, and we are allowed to have 30
    anyway, i think we're pushing the limit now with our site, we've been growing quite fast lately.. the site i'm talking about here is www.gizmozone.com..

Similar Threads

  1. Mysql problem.
    By Nik in forum MySQL Help
    Replies: 54
    Last Post: December 21st, 2006, 07:02 PM
  2. server load of 358?
    By Paulp75 in forum Apache Development
    Replies: 0
    Last Post: February 16th, 2004, 07:37 PM
  3. Replies: 0
    Last Post: February 11th, 2004, 03:56 PM
  4. general web server question
    By black_lotus in forum Apache Development
    Replies: 3
    Last Post: February 7th, 2004, 01:12 AM
  5. Windows 2000 Advanced Server CAL Question
    By JohnSaunders in forum Windows Help
    Replies: 3
    Last Post: January 20th, 2004, 01:13 AM

IMN logo majestic logo threadwatch logo seochat tools logo