Page 3 of 4 FirstFirst 1234 LastLast
Results 31 to 45 of 50

Thread: So has the server been more stable?

  1. #31
    Ominous Wanderer Tech Admin Samuraid's Avatar
    Join Date
    Oct 2001
    Posts
    5,522

    Default

    Quote Originally Posted by Loony BoB
    I'm not really sure how attachments in the database works, only that I never liked the idea of it (the only time I'd use it is if I wanted to back up every single part of the forums on a single database file for some kind of reason, but even then you can just download the images via FTP and then zip 'em)
    Yeah, having the attachments in the database does make it easier to pack everything up in one nice location. It is a bigger drain on the server though as you get large files sitting in memory while a user downloads them. (as opposed to normal files on the webserver that can be cached in blocks at apache's leisure)

  2. #32
    Newbie Administrator Loony BoB's Avatar
    Join Date
    Aug 2000
    Posts
    52,471
    Articles
    53
    Blog Entries
    19

    FFXIV Character

    Loony Bob (Twintania)

    Default

    I'll get this done sometime tomorrow during the British working hours (in other words, the EoFF dead zone).
    Bow before the mighty Javoo!

  3. #33
    Last Exile Baloki's Avatar
    Join Date
    Sep 2003
    Location
    Dreaming a dream~
    Posts
    8,425
    Articles
    5
    Blog Entries
    2

    FFXIV Character

    Baloki Kyuu (Sargatanas)
    Contributions
    • Former Senior Site Staff

    Default

    Quote Originally Posted by Loony BoB
    I'll get this done sometime tomorrow during the British working hours (in other words, the EoFF dead zone).
    *Flashes some kind of forgotten memory*

    Welcome to the DEAD ZONE on Sci Fi :P
    FOA

  4. #34
    ORANGE Dr Unne's Avatar
    Join Date
    Dec 1999
    Posts
    7,394
    Articles
    1
    Contributions
    • Former Administrator
    • Former Developer
    • Former Tech Admin

    Default

    I would take a blind guess and say that moving attachments out of the database will definitely make things go faster, yeah. Filesystem access is definitely going to be faster than a database query, but how many orders of magnitude faster, I couldn't say.

  5. #35
    Away Founder Cid's Avatar
    Join Date
    Dec 1999
    Location
    In your tree.
    Posts
    2,049
    Articles
    141
    Contributions
    • Created Eyes on Final Fantasy
    • Former Administrator

    Default

    Yeah, the attachments take up 347.60MB of our 553.94MB total database.

  6. #36
    Hypnotising you crono_logical's Avatar
    Join Date
    May 2001
    Location
    Back in Time
    Posts
    9,313
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    Quote Originally Posted by Loony BoB
    EDIT: Actually, that was never an admin CP feature, now that I think about it - I think Cid's just disallowed remote linking completely at EoFF. If that's the case, it shouldn't be any trouble.
    It's under usergroup permissions - guests are denied downloading attachments, last time I saw. But yeah, if Cid's done that remote linking block thing, I guess most of the problem is gone except for people using EoFF to host their EoFF sigs


    Problems playing downloaded videos? Try CCCP


  7. #37
    cyka blyat escobert's Avatar
    Join Date
    Apr 2001
    Location
    Rush B! NO STOP!
    Posts
    17,742
    Blog Entries
    4

    Default

    It gets slow for me every once in a whiloe when I try to post but nothing too baad.

  8. #38
    rowr Recognized Member Leeza's Avatar
    Join Date
    Aug 2001
    Location
    The long hard road out of hell.
    Posts
    17,979
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    Lots and lots of lag all morning in posting and browsing.
    Hello Pika Art by Dr Unne ~~~ godhatesfraggles

  9. #39
    ORANGE Dr Unne's Avatar
    Join Date
    Dec 1999
    Posts
    7,394
    Articles
    1
    Contributions
    • Former Administrator
    • Former Developer
    • Former Tech Admin

    Default

    Ditto that.

  10. #40
    Newbie Administrator Loony BoB's Avatar
    Join Date
    Aug 2000
    Posts
    52,471
    Articles
    53
    Blog Entries
    19

    FFXIV Character

    Loony Bob (Twintania)

    Default

    I'm still waiting for Cid to send me some server information so I can go ahead with the attachment storage change. I need the root directory path and it looks like the various common ones didn't work, so we'll have to wait until Cid replies to my PM. If it's still slow after that, I'm not too sure on exactly where we should look to next, but I'm sure we'll figure it out.
    Bow before the mighty Javoo!

  11. #41
    Last Exile Baloki's Avatar
    Join Date
    Sep 2003
    Location
    Dreaming a dream~
    Posts
    8,425
    Articles
    5
    Blog Entries
    2

    FFXIV Character

    Baloki Kyuu (Sargatanas)
    Contributions
    • Former Senior Site Staff

    Default

    I keep getting the following message in the mornings

    This is Loony BoB your overlord, sup biatchies, now why you visiting here hommies. I'm currently doing some attachment moving, uh huh baby back in a min, so clear off and try again in a few mins, shouldn't take too long
    I'm suspicious of him becoming a gangster during file movements...
    FOA

  12. #42
    Feel the Bern Administrator Del Murder's Avatar
    Join Date
    Jun 2001
    Location
    Oakland, California
    Posts
    41,733
    Articles
    6
    Blog Entries
    2
    Contributions
    • Former Cid's Knight
    • Former Administrator
    • Hosted the Ciddies

    Default

    Man, why don't you and BoB just get married already and be done with it.

    Proud to be the Unofficial Secret Illegal Enforcer of Eyes on Final Fantasy!
    When I grow up, I want to go to Bovine Trump University! - Ralph Wiggum

  13. #43
    Last Exile Baloki's Avatar
    Join Date
    Sep 2003
    Location
    Dreaming a dream~
    Posts
    8,425
    Articles
    5
    Blog Entries
    2

    FFXIV Character

    Baloki Kyuu (Sargatanas)
    Contributions
    • Former Senior Site Staff

    Default

    Quote Originally Posted by Super Delete
    Man, why don't you and BoB just get married already and be done with it.
    I did prepose but he turned me down
    FOA

  14. #44
    lomas de chapultepec Recognized Member eestlinc's Avatar
    Join Date
    Jun 2000
    Location
    brooklyn
    Posts
    17,552
    Contributions
    • Former Cid's Knight

    Default

    I guess he has standards after all.

  15. #45
    Last Exile Baloki's Avatar
    Join Date
    Sep 2003
    Location
    Dreaming a dream~
    Posts
    8,425
    Articles
    5
    Blog Entries
    2

    FFXIV Character

    Baloki Kyuu (Sargatanas)
    Contributions
    • Former Senior Site Staff

    Default

    Quote Originally Posted by eestlinc
    I guess he has standards after all.
    *Hates you*
    FOA

Posting Permissions

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