Page 4 of 5 FirstFirst 12345 LastLast
Results 31 to 40 of 45

Thread: Slow loading

  1. #31
    Publisher Facebook Connected bartmoss's Avatar
    Join Date
    Mar 2008
    Location
    Berlin, Germany
    Posts
    904
    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
    Administrator Facebook Connected Robbie's Avatar
    Join Date
    Mar 2006
    Location
    Dayton, OH
    Posts
    3,877
    Blog Entries
    6

    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
    Fantaseum (https://www.fantaseum.com)

    Robbie Powell - Site Admin

  3. #33
    Publisher Facebook Connected bartmoss's Avatar
    Join Date
    Mar 2008
    Location
    Berlin, Germany
    Posts
    904
    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
    Administrator Facebook Connected Robbie's Avatar
    Join Date
    Mar 2006
    Location
    Dayton, OH
    Posts
    3,877
    Blog Entries
    6

    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?
    Fantaseum (https://www.fantaseum.com)

    Robbie Powell - Site Admin

  5. #35

    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
    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
    Administrator Facebook Connected Robbie's Avatar
    Join Date
    Mar 2006
    Location
    Dayton, OH
    Posts
    3,877
    Blog Entries
    6

    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.
    Fantaseum (https://www.fantaseum.com)

    Robbie Powell - Site Admin

  8. #38

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

    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
    Administrator Facebook Connected Robbie's Avatar
    Join Date
    Mar 2006
    Location
    Dayton, OH
    Posts
    3,877
    Blog Entries
    6

    Default

    Still working on further improvements...thanks for the feedback
    Fantaseum (https://www.fantaseum.com)

    Robbie Powell - Site Admin

Page 4 of 5 FirstFirst 12345 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
  •