Results 1 to 4 of 4

Thread: SQL problems

  1. #1

    SQL problems

    I manage a web site (Quickjams.com) that hosts song lyrics for various artists. I have SQL disk usage that is currently 21.8Mb. on my server and growing. Recently the load time on the site has plummeted. and the SQL is growing daily. Anyone have any server suggestions? I estimate that total SQL disk usage wil top out at 85-100Mb. Any suggestions on improving load time, or anything else that would help?

    adamsteve@gmail.com

  2. #2
    Join Date
    Dec 2001
    Location
    127.0.0.1
    Posts
    3,642
    Quote Originally Posted by Steveadams
    I manage a web site (Quickjams.com) that hosts song lyrics for various artists. I have SQL disk usage that is currently 21.8Mb. on my server and growing. Recently the load time on the site has plummeted. and the SQL is growing daily. Anyone have any server suggestions? I estimate that total SQL disk usage wil top out at 85-100Mb. Any suggestions on improving load time, or anything else that would help?

    adamsteve@gmail.com
    www.elix.us has some tutorials that might help.
    Simpli Networks, LLC :: http://www.simplinetworks.com :: Proudly 100% Owned.
    Providing Affordable Managed Cloud/VPS Servers & Server Management Solutions.
    We offer REAL 24x7x365 in-house support - proudly serving our customers since 2005!
    Want to learn more? Give us a call - +1 (844) 4SIMPLI or email sales[@]simplinetworks.com today!

  3. #3
    Join Date
    Mar 2003
    Location
    tail -f /var/log/nerd
    Posts
    318
    Quote Originally Posted by Steveadams
    Recently the load time on the site has plummeted.

    intr.v. plum·met·ed, plum·met·ing, plum·mets
    To fall straight down; plunge.
    To decline suddenly and steeply: Stock prices plummeted.

    I think what you ment to say was the load was sky rocketing? Meaning it was getting loaded up quite heavily.
    Mega Hosters Inc. - The Last Host You Will Ever Need!
    Hsphere Control Panel, 24/7 Phone Support, EasyApp, Shared SSL, Daily Backups, Dedicated IPs, PHP4 & PHP5, FFMPEG, Legal Adult Content Allowed + More!
    Treating A Customer The Way They Should Be Treated For Over 5.5 Years Now!

  4. #4
    Join Date
    Dec 2005
    Location
    Finland
    Posts
    1,471
    Hi,

    what kind of setup is this? Shared server, VPS, dedicated... I'm no expert in this, but that database seems quite small actually.

Posting Permissions

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