Page 4 of 5 FirstFirst ... 2345 LastLast
Results 31 to 40 of 45

Thread: Slow loading

  1. #31
      bartmoss is offline
    Publisher Gracious Donor
    Facebook Connected
    bartmoss's Avatar
    Join Date
    Mar 2008
    Location
    Berlin, Germany
    Posts
    895
    Blog Entries
    1

    Default

    MyISAM is fine - unless you write to a busy table. If that happens, table locking will definitely kill you. In my experience, the InnoDB performance overhead is not an issue, but of course this will vary according to your specific situation. And also of course, InnoDB has other things to consider (need to be smart about the tablespaces, since they won't shrink automatically.)

    Don't know Sphinx or what you'll use it for (sounds to me that it's useful for the site's search engine.)

  2. #32
      Arcana is offline
    Administrator Facebook Connected Arcana's Avatar
    Join Date
    Mar 2006
    Location
    Fairborn, OH
    Posts
    2,772
    Blog Entries
    5

    Default

    Quote Originally Posted by RobA View Post
    We are also on a trial on a dedicated mysql server, so some of yesterday's performance issues were related to transferring the database.... all 1.6GB of it...while leaving the site up.

    -RobA>
    Total DB size is now 433 megabytes....lol...much more manageable
    Robbie Powell - Site Admin

  3. #33
      bartmoss is offline
    Publisher Gracious Donor
    Facebook Connected
    bartmoss's Avatar
    Join Date
    Mar 2008
    Location
    Berlin, Germany
    Posts
    895
    Blog Entries
    1

    Default

    Quote Originally Posted by Arcana View Post
    Total DB size is now 433 megabytes....lol...much more manageable
    One word: CUTE.

    That's nothing. :-)

  4. #34
      Arcana is offline
    Administrator Facebook Connected Arcana's Avatar
    Join Date
    Mar 2006
    Location
    Fairborn, OH
    Posts
    2,772
    Blog Entries
    5

    Default

    Quote Originally Posted by bartmoss View Post
    MyISAM is fine - unless you write to a busy table. If that happens, table locking will definitely kill you. In my experience, the InnoDB performance overhead is not an issue, but of course this will vary according to your specific situation. And also of course, InnoDB has other things to consider (need to be smart about the tablespaces, since they won't shrink automatically.)

    Don't know Sphinx or what you'll use it for (sounds to me that it's useful for the site's search engine.)
    From what I'm reading, yes it is...I need to make sure I can install it on our server. I think we can install whatever we want. How are the load times for you right now?
    Robbie Powell - Site Admin

  5. #35
      ravells is offline
    Community Leader Gracious Donor ravells's Avatar
    Join Date
    Jun 2006
    Location
    London, UK
    Posts
    10,900

    Default

    I don't know about anyone else but since Robbie posted about redoing the table the loading speed has really improved for me. Not sure if it's a coincidence and might slow down again, but I hope not!

  6. #36
      Thesslian is offline
    Guild Member Thesslian's Avatar
    Join Date
    Jan 2012
    Location
    Indiana
    Posts
    78

    Default

    Well, today the forum seems to be flying. Only takes three or four seconds for a page to load, as opposed to a minute or two that it was a few days ago. Being so new here I thought it was always slow.

  7. #37
      Arcana is offline
    Administrator Facebook Connected Arcana's Avatar
    Join Date
    Mar 2006
    Location
    Fairborn, OH
    Posts
    2,772
    Blog Entries
    5

    Default

    Quote Originally Posted by ravells View Post
    I don't know about anyone else but since Robbie posted about redoing the table the loading speed has really improved for me. Not sure if it's a coincidence and might slow down again, but I hope not!
    There's no coincidence, only carefully calculated results from carefully executed procedures...lol.
    Robbie Powell - Site Admin

  8. #38

  9. #39
      maxsdaddy is offline
    Guild Journeyer maxsdaddy's Avatar
    Join Date
    Oct 2011
    Location
    Westfield, NJ USA
    Posts
    189

    Default

    "only carefully calculated results from carefully executed procedures" Great work from the SA's. Home page loaded in about three seconds, forums even less. Kudo's and thanks.

  10. #40
      Arcana is offline
    Administrator Facebook Connected Arcana's Avatar
    Join Date
    Mar 2006
    Location
    Fairborn, OH
    Posts
    2,772
    Blog Entries
    5

    Default

    Still working on further improvements...thanks for the feedback
    Robbie Powell - Site Admin

Page 4 of 5 FirstFirst ... 2345 LastLast

Posting Permissions

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