1 user browsing Discussion: tomman | 20 bots
| Duck Penis |
Posted on 19-05-09, 14:01 (revision 1)
|
|
Stirrer of Shit
Post: #255 of 717 Since: 01-26-19 Last post: 1763 days Last view: 1762 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. |
| tomman |
Posted on 19-05-09, 16:31
|
|
Dinosaur
 Post: #309 of 1316 Since: 10-30-18 Last post: 5 hours Last view: 2 min. User is online |
Time to migrate to PostgreSQL. Licensed Pirate® since 2006, 100% Buttcoin™-free, enemy of All Things JavaScript™ |
| Duck Penis |
Posted on 19-05-09, 16:39
|
|
Stirrer of Shit
Post: #257 of 717 Since: 01-26-19 Last post: 1763 days Last view: 1762 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. |
| Kawaoneechan |
Posted on 19-05-09, 22:52
|
|
Secretly, I'm Patrick Stewart
 Post: #218 of 599 Since: 10-29-18 Last post: 196 days Last view: 1 hour |
It may be oddly slow sometimes, but it's not exactly breaking apart. And if it ain't broken... |
| CaptainJistuce |
Posted on 19-05-09, 23:51
|
|
Custom title here
 Post: #441 of 1164 Since: 10-30-18 Last post: 63 days Last view: 16 hours |
Posted by KawaIf it ain't broken, improve it 'til it is. --- In UTF-16, where available. --- |
| Nicholas Steel |
Posted on 19-05-10, 02:32
|
|
Post: #190 of 426
Since: 10-30-18 Last post: 499 days Last view: 14 days |
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 |
| CaptainJistuce |
Posted on 19-05-10, 03:09
|
|
Custom title here
Post: #443 of 1164 Since: 10-30-18 Last post: 63 days Last view: 16 hours |
Posted by Nicholas SteelWord. --- In UTF-16, where available. --- |
| nyanpasu64 |
Posted on 19-05-10, 05:24 (revision 2)
|
|
Post: #44 of 77
Since: 10-31-18 Last post: 1190 days Last view: 1116 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. |
| tomman |
Posted on 19-05-10, 11:39
|
|
Dinosaur
Post: #311 of 1316 Since: 10-30-18 Last post: 5 hours Last view: 2 min. User is online |
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™ |
| Duck Penis |
Posted on 19-05-10, 13:10
|
|
Stirrer of Shit
Post: #258 of 717 Since: 01-26-19 Last post: 1763 days Last view: 1762 days |
Posted by jimbo1qaz 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. |
| Kawaoneechan |
Posted on 19-05-10, 14:15
|
|
Can Breathe in Space
Post: #219 of 599 Since: 10-29-18 Last post: 196 days Last view: 1 hour |
Posted by Nicholas SteelAds are on the bottom, blackjack and hookers are in the hidden staff area. |
| tomman |
Posted on 19-05-10, 16:27 (revision 2)
|
|
Dinosaur
Post: #312 of 1316 Since: 10-30-18 Last post: 5 hours Last view: 2 min. User is online |
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™ |
| Duck Penis |
Posted on 19-05-10, 16:42
|
|
Stirrer of Shit
Post: #259 of 717 Since: 01-26-19 Last post: 1763 days Last view: 1762 days |
Yeah, it's only the threads. I did some testing, where I requested random POST IDs (?pid=) and wrote down the load time: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: 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. |
| Kawaoneechan |
Posted on 19-05-10, 18:42
|
|
Secretly, I'm Rainbow Dash
Post: #220 of 599 Since: 10-29-18 Last post: 196 days Last view: 1 hour |
Posted by sureanemCorrect on both counts -- they are indexed on post ID, and the all boards on this server are variations on the same ABXD codebase. |
| Duck Penis |
Posted on 19-05-10, 18:48
|
|
Stirrer of Shit
Post: #261 of 717 Since: 01-26-19 Last post: 1763 days Last view: 1762 days |
Posted by Kawa 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. |
| Kawaoneechan |
Posted on 19-05-10, 19:22
|
|
Tired
Post: #221 of 599 Since: 10-29-18 Last post: 196 days Last view: 1 hour |
At least so far as the threads and posts go, they are identical. The version numbering is a joke, ignore it. |
| Duck Penis |
Posted on 19-05-10, 19:59
|
|
Stirrer of Shit
Post: #262 of 717 Since: 01-26-19 Last post: 1763 days Last view: 1762 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. |
| Kawaoneechan |
Posted on 19-05-10, 20:07
|
|
Affected by a raging stiffie
Post: #222 of 599 Since: 10-29-18 Last post: 196 days Last view: 1 hour |
"Optimize table" is a thing I did right after that post. So maybe cruft removal helps. |
| Duck Penis |
Posted on 19-05-10, 20:23
|
|
Stirrer of Shit
Post: #264 of 717 Since: 01-26-19 Last post: 1763 days Last view: 1762 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. |
| Duck Penis |
Posted on 19-05-11, 18:28
|
|
Stirrer of Shit
Post: #268 of 717 Since: 01-26-19 Last post: 1763 days Last view: 1762 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. |
