0 users browsing Discussion. | 13 bots  
    Main » Discussion » Board feature requests/suggestions
    Pages: First Previous 8 9 10 11 12 13 14 15 16 17 18 Next Last
    Posted on 19-05-09, 14:01 (revision 1)
    Stirrer of Shit
    Post: #255 of 717
    Since: 01-26-19

    Last post: 1526 days
    Last view: 1524 days
    Page rendered in 1.067 seconds with 20 MySQL queries.

    Is your board doing okay?

    EDIT:
    Page rendered in 8.076 seconds with 27 MySQL queries.

    Page rendered in 1.192 seconds with 15 MySQL queries.

    "Last posts" is ~5 ms, short threads the same, but longer threads appear to load far slower.

    There was a certain photograph about which you had a hallucination. You believed that you had actually held it in your hands. It was a photograph something like this.
    Posted on 19-05-09, 16:31
    Dinosaur

    Post: #309 of 1282
    Since: 10-30-18

    Last post: 5 days
    Last view: 11 hours
    Time to migrate to PostgreSQL.

    Licensed Pirate® since 2006, 100% Buttcoin™-free, enemy of All Things JavaScript™
    Posted on 19-05-09, 16:39
    Stirrer of Shit
    Post: #257 of 717
    Since: 01-26-19

    Last post: 1526 days
    Last view: 1524 days
    It's often but not always close to a whole number of seconds (in this tab here: "Page rendered in 0.943 seconds with 21 MySQL queries."). There was an issue very similar to this that someone was having with SQLite, it was sleeping a whole second to try and resolve some conflict. Could this be the case here?

    Although sometimes I get other times, like 0.138, 0.558, or 0.555.

    There was a certain photograph about which you had a hallucination. You believed that you had actually held it in your hands. It was a photograph something like this.
    Posted on 19-05-09, 22:52
    TV Troper

    Post: #218 of 598
    Since: 10-29-18

    Last post: 87 days
    Last view: 3 hours
    It may be oddly slow sometimes, but it's not exactly breaking apart. And if it ain't broken...
    Posted on 19-05-09, 23:51
    Custom title here

    Post: #441 of 1150
    Since: 10-30-18

    Last post: 7 days
    Last view: 8 hours
    Posted by Kawa
    It may be oddly slow sometimes, but it's not exactly breaking apart. And if it ain't broken...
    If it ain't broken, improve it 'til it is.

    --- In UTF-16, where available. ---
    Posted on 19-05-10, 02:32
    Post: #190 of 426
    Since: 10-30-18

    Last post: 261 days
    Last view: 1 day
    Forum needs advertisements, black jack and hookers in order to improve performance.

    AMD Ryzen 3700X | MSI Gamer Geforce 1070Ti 8GB | 16GB 3600MHz DDR4 RAM | ASUS Crosshair VIII Hero (WiFi) Motherboard | Windows 10 x64
    Posted on 19-05-10, 03:09
    Custom title here

    Post: #443 of 1150
    Since: 10-30-18

    Last post: 7 days
    Last view: 8 hours
    Posted by Nicholas Steel
    Forum needs advertisements, black jack and hookers in order to improve performance.
    Word.

    --- In UTF-16, where available. ---
    Posted on 19-05-10, 05:24 (revision 2)
    Post: #44 of 77
    Since: 10-31-18

    Last post: 952 days
    Last view: 879 days
    https://helmet.kafuka.org/bboard/lastposts.php loaded quickly.
    I click this thread and it isn't loading.
    After waiting for over 10 seconds, I opened 2 other posts which start loading quickly, followed by this thread finally finishing.

    >Page rendered in 15.953 seconds with 30 MySQL queries.

    that's 16 seconds.

    -------

    POSTing the "edit" to this post took close to 10 seconds to load. But the thread self-reported to have rendered in <1 second.
    Posted on 19-05-10, 11:39
    Dinosaur

    Post: #311 of 1282
    Since: 10-30-18

    Last post: 5 days
    Last view: 11 hours
    Oh, so it's not my horrible connection then. THIS TIME.

    Been noticing the same delays at random, but dismissed those as "ugh, not again...".

    Licensed Pirate® since 2006, 100% Buttcoin™-free, enemy of All Things JavaScript™
    Posted on 19-05-10, 13:10
    Stirrer of Shit
    Post: #258 of 717
    Since: 01-26-19

    Last post: 1526 days
    Last view: 1524 days
    Posted by jimbo1qaz
    https://helmet.kafuka.org/bboard/lastposts.php loaded quickly.
    I click this thread and it isn't loading.
    After waiting for over 10 seconds, I opened 2 other posts which start loading quickly, followed by this thread finally finishing.

    >Page rendered in 15.953 seconds with 30 MySQL queries.

    that's 16 seconds.

    -------

    POSTing the "edit" to this post took close to 10 seconds to load. But the thread self-reported to have rendered in <1 second.

    Only the threads have the load time issue, in particular longer threads.

    I think it goes into (database-level) cache if you refresh a few times, which causes the page load time to become normal again.

    There was a certain photograph about which you had a hallucination. You believed that you had actually held it in your hands. It was a photograph something like this.
    Posted on 19-05-10, 14:15
    FMOD user

    Post: #219 of 598
    Since: 10-29-18

    Last post: 87 days
    Last view: 3 hours
    Posted by Nicholas Steel
    Forum needs advertisements, black jack and hookers in order to improve performance.
    Ads are on the bottom, blackjack and hookers are in the hidden staff area.
    Posted on 19-05-10, 16:27 (revision 2)
    Dinosaur

    Post: #312 of 1282
    Since: 10-30-18

    Last post: 5 days
    Last view: 11 hours
    Open main page (instant)->enter Discussion board(~0.01sec)->go to the last post to this thread:
    Page rendered in 10.723 seconds with 28 MySQL queries.


    Edit this post(1 sec)->post(1.1 sec)->edit again (1 sec).

    Licensed Pirate® since 2006, 100% Buttcoin™-free, enemy of All Things JavaScript™
    Posted on 19-05-10, 16:42
    Stirrer of Shit
    Post: #259 of 717
    Since: 01-26-19

    Last post: 1526 days
    Last view: 1524 days
    Yeah, it's only the threads. I did some testing, where I requested random POST IDs (?pid=) and wrote down the load time:
    127     0.624
    251 3.678
    454 0.027
    473 1.020
    742 1.476
    1143 0.242
    1209 0.565
    1272 7.732
    1462 9.300
    1669 0.021
    1707 0.985
    1875 1.552
    1974 0.022
    2065 0.091
    2280 6.400 *OP
    2314 1.032
    2540 6.904
    2704 24.238

    It seems like there's a split, between load times <2s and >3s (no load times between 2-3s).
    Those above 3s appear to have a slight correlation to post ID. So speculating wildly, it could be doing a linear scan for those.
    Although it doesn't explain why it's so close to whole seconds.
    If I do it with ?id=X:
    36      0.026
    56 0.008
    64 0.057
    72 0.051

    Normal load times.

    Does the database have an index on post ID? If not, that could be it. It doesn't seem like the other boards on this domain have the same issue, and I'm assuming the code is very similar.



    There was a certain photograph about which you had a hallucination. You believed that you had actually held it in your hands. It was a photograph something like this.
    Posted on 19-05-10, 18:42
    Off-Model

    Post: #220 of 598
    Since: 10-29-18

    Last post: 87 days
    Last view: 3 hours
    Posted by sureanem
    Does the database have an index on post ID? If not, that could be it. It doesn't seem like the other boards on this domain have the same issue, and I'm assuming the code is very similar.
    Correct on both counts -- they are indexed on post ID, and the all boards on this server are variations on the same ABXD codebase.
    Posted on 19-05-10, 18:48
    Stirrer of Shit
    Post: #261 of 717
    Since: 01-26-19

    Last post: 1526 days
    Last view: 1524 days
    Posted by Kawa
    Posted by sureanem
    Does the database have an index on post ID? If not, that could be it. It doesn't seem like the other boards on this domain have the same issue, and I'm assuming the code is very similar.
    Correct on both counts -- they are indexed on post ID, and the all boards on this server are variations on the same ABXD codebase.

    Are the database schemata entirely identical, then?

    Also, what's up with the version numbers? If I refresh the main page, the version number changes!

    There was a certain photograph about which you had a hallucination. You believed that you had actually held it in your hands. It was a photograph something like this.
    Posted on 19-05-10, 19:22
    A punch comes free with most major felinies

    Post: #221 of 598
    Since: 10-29-18

    Last post: 87 days
    Last view: 3 hours
    At least so far as the threads and posts go, they are identical.

    The version numbering is a joke, ignore it.
    Posted on 19-05-10, 19:59
    Stirrer of Shit
    Post: #262 of 717
    Since: 01-26-19

    Last post: 1526 days
    Last view: 1524 days


    Maybe you could open up the query profiler or whatever they call it and see what's going on inside.

    But it seems to have stopped now. So no reason to do anything, really.

    There was a certain photograph about which you had a hallucination. You believed that you had actually held it in your hands. It was a photograph something like this.
    Posted on 19-05-10, 20:07
    Not the Messiah

    Post: #222 of 598
    Since: 10-29-18

    Last post: 87 days
    Last view: 3 hours
    "Optimize table" is a thing I did right after that post. So maybe cruft removal helps.
    Posted on 19-05-10, 20:23
    Stirrer of Shit
    Post: #264 of 717
    Since: 01-26-19

    Last post: 1526 days
    Last view: 1524 days
    Page rendered in 1.025 seconds with 27 MySQL queries.

    Or maybe not.

    There was a certain photograph about which you had a hallucination. You believed that you had actually held it in your hands. It was a photograph something like this.
    Posted on 19-05-11, 18:28
    Stirrer of Shit
    Post: #268 of 717
    Since: 01-26-19

    Last post: 1526 days
    Last view: 1524 days
    Odd, it's not just the threads doing it.

    Tried to delete some PMs. First one was instant (0.006 s), second one?

    Page rendered in 10.985 seconds with 19 MySQL queries.


    Well, it remains a mystery.

    There was a certain photograph about which you had a hallucination. You believed that you had actually held it in your hands. It was a photograph something like this.
    Pages: First Previous 8 9 10 11 12 13 14 15 16 17 18 Next Last
      Main » Discussion » Board feature requests/suggestions
      This does not actually go there and I regret nothing.