Home Home Calendar Calendar Search Search Register Register Login Login
Welcome, Guest.
Please login or register.
Fishy Forum › Fishy Boards › Archive › Site speed
Users Browsing Forum
No Members and 195 Guests

Site speed

  This thread currently has 3,936 views. Print
3 Pages 1 2 3 All Recommend Thread
GrimRob
October 19, 2018, 9:16pm

Moderator
Posts: 12,672
Posts Per Day: 2.12
Reputation: 69.92%
Rep Score: +76 / -34
Approval: +13,403
Gold Stars: 113
I know the site has been slow today. I have identified the problem and am hoping for a fix soon.

Apologies for the slowness.


'Tis better to have loved and lost than never to have loved at all.  
~ Alfred Lord Tennyson
Logged Offline
Site Private Message Skype
3
1
0
promotion plaice
October 19, 2018, 9:25pm

Moderator
Posts: 19,625
Posts Per Day: 3.85
Reputation: 64.79%
Rep Score: +20 / -13
Location: Cleethorpes
Approval: +17,048
Gold Stars: 197

Yeah ....it's painfully slow for me at the moment.


When Leeds trainer Les Cocker was once told Norman Hunter had broken a leg, he asked: “Whose is it?”
Logged Offline
Private Message
1
1
0
 Reply: 1 - 23
golfer
October 19, 2018, 9:26pm
Vodka Drinker
Posts: 6,920
Posts Per Day: 2.30
Reputation: 67.55%
Rep Score: +34 / -18
Approval: +3,429
Gold Stars: 115
Fcook me-it's that slow I didn't know the Mansfield game was postponed
Logged Offline
Private Message
12
1
0
 Reply: 2 - 23
GrimRob
October 19, 2018, 9:39pm

Moderator
Posts: 12,672
Posts Per Day: 2.12
Reputation: 69.92%
Rep Score: +76 / -34
Approval: +13,403
Gold Stars: 113
Any better? I killed off some rogue connections


'Tis better to have loved and lost than never to have loved at all.  
~ Alfred Lord Tennyson
Logged Offline
Site Private Message Skype
1
1
0
 Reply: 3 - 23
promotion plaice
October 19, 2018, 9:44pm

Moderator
Posts: 19,625
Posts Per Day: 3.85
Reputation: 64.79%
Rep Score: +20 / -13
Location: Cleethorpes
Approval: +17,048
Gold Stars: 197
Quoted from GrimRob
Any better? I killed off some rogue connections


Miles better for me now Rob  



When Leeds trainer Les Cocker was once told Norman Hunter had broken a leg, he asked: “Whose is it?”
Logged Offline
Private Message
1
1
0
 Reply: 4 - 23
GrimRob
October 19, 2018, 9:47pm

Moderator
Posts: 12,672
Posts Per Day: 2.12
Reputation: 69.92%
Rep Score: +76 / -34
Approval: +13,403
Gold Stars: 113
Yeah I know what's caused it. The code is not particularly efficient in one area. As the database has grown it's materialised in a problem. I'll be able to fix it but for now it's under control I think.


'Tis better to have loved and lost than never to have loved at all.  
~ Alfred Lord Tennyson
Logged Offline
Site Private Message Skype
2
1
0
 Reply: 5 - 23
LH
October 19, 2018, 10:01pm

Moderator
Posts: 11,475
Posts Per Day: 1.92
Reputation: 71.54%
Rep Score: +30 / -13
Approval: +18,500
Gold Stars: 173
Quoted from GrimRob
Any better? I killed off some rogue connections


What were their usernames?
Logged
Private Message
3
0
0
 Reply: 6 - 23
fishyfanny
October 19, 2018, 10:14pm
Barley Wine Drinker
Posts: 14,234
Posts Per Day: 4.90
Reputation: 85.92%
Rep Score: +4 / 0
Location: Waltham
Approval: +1,516
Gold Stars: 15
Quoted from GrimRob
Yeah I know what's caused it. The code is not particularly efficient in one area. As the database has grown it's materialised in a problem. I'll be able to fix it but for now it's under control I think.


Yeah that's what I thought😏
Logged Offline
Private Message
5
0
0
 Reply: 7 - 23
GrimRob
October 19, 2018, 10:17pm

Moderator
Posts: 12,672
Posts Per Day: 2.12
Reputation: 69.92%
Rep Score: +76 / -34
Approval: +13,403
Gold Stars: 113
Quoted from LH


What were their usernames?


I don't know and it's not anyone's fault, it's just a rare combination of events cascading to cause a problem. When someone visits a page it fires off a load of queries. Normally they return data. If the database is busy very occasionally it kicks the query out, but the site retries so the user won't even notice other than a small delay. All I can do is make sure the site doesn't ask for too much too often, and what it does ask for is returned quickly. The code has worked more or less perfectly for 5 years it just picked today to go wrong.


'Tis better to have loved and lost than never to have loved at all.  
~ Alfred Lord Tennyson
Logged Offline
Site Private Message Skype
2
1
0
 Reply: 8 - 23
lew chaterleys lover
October 19, 2018, 10:50pm
Vodka Drinker
Posts: 5,005
Posts Per Day: 1.07
Reputation: 75.9%
Rep Score: +30 / -10
Approval: +10,716
Gold Stars: 236
Quoted from GrimRob


I don't know and it's not anyone's fault, it's just a rare combination of events cascading to cause a problem. When someone visits a page it fires off a load of queries. Normally they return data. If the database is busy very occasionally it kicks the query out, but the site retries so the user won't even notice other than a small delay. All I can do is make sure the site doesn't ask for too much too often, and what it does ask for is returned quickly. The code has worked more or less perfectly for 5 years it just picked today to go wrong.


I thought it might be that.
Logged
Private Message
5
1
0
 Reply: 9 - 23
denni266
October 19, 2018, 10:59pm

Whiskey Drinker
Posts: 4,289
Posts Per Day: 0.83
Reputation: 47.09%
Rep Score: +13 / -21
Approval: +696
Gold Stars: 132
I didnt have a clue lol
Logged Offline
Private Message
0
0
0
 Reply: 10 - 23
KingstonMariner
October 19, 2018, 11:00pm
Meths Drinker
Posts: 22,096
Posts Per Day: 6.07
Reputation: 79.33%
Rep Score: +42 / -11
Approval: +23,440
Gold Stars: 218
Quoted from GrimRob
Any better? I killed off some rogue connections


So it was you that did Berezhovsky, Litvinenko and tried to do Skripal. Oh and that bloke just does the road in New Malden.


Through the door there came familiar laughter,
I saw your face and heard you call my name.
Oh my friend we're older but no wiser,
For in our hearts the dreams are still the same.
Logged Offline
Private Message
1
0
0
 Reply: 11 - 23
GYinScuntland
October 20, 2018, 1:19am

Brandy Drinker
Posts: 2,601
Posts Per Day: 0.49
Reputation: 78.29%
Rep Score: +21 / -6
Location: Ashby, Scunthorpe
Approval: +3,238
Gold Stars: 97
It's so slow it's tomorrow.
Logged Offline
Private Message
1
0
0
 Reply: 12 - 23
Mallyner
October 20, 2018, 8:08am
Cocktail Drinker
Posts: 1,788
Posts Per Day: 0.60
Reputation: 80.9%
Rep Score: +9 / -2
Location: New Waltham
Approval: +2,515
Gold Stars: 23
Quoted from GrimRob


I don't know and it's not anyone's fault, it's just a rare combination of events cascading to cause a problem. When someone visits a page it fires off a load of queries. Normally they return data. If the database is busy very occasionally it kicks the query out, but the site retries so the user won't even notice other than a small delay. All I can do is make sure the site doesn't ask for too much too often, and what it does ask for is returned quickly. The code has worked more or less perfectly for 5 years it just picked today to go wrong.


Was this the code Russell Slade was demonstrating at the forum?  


Supporting Town for 65 years.  
Logged Offline
Private Message
2
0
0
 Reply: 13 - 23
GrimRob
October 20, 2018, 11:48am

Moderator
Posts: 12,672
Posts Per Day: 2.12
Reputation: 69.92%
Rep Score: +76 / -34
Approval: +13,403
Gold Stars: 113
I have implemented Phase 1 of the speed improvement fix. Everything should appear the same. Hopefully, it will be slightly quicker loading the list of messages on the board, which was where the problem was. I'll have a go at Phase 2 when I add some additional caching in the next day or two.

You can see how it is doing here

https://stats.uptimerobot.com/j0qkzt87k/779680064

UPDATE: Phase 2 is now done


'Tis better to have loved and lost than never to have loved at all.  
~ Alfred Lord Tennyson
Logged Offline
Site Private Message Skype
1
1
0
 Reply: 14 - 23
golfer
October 20, 2018, 12:26pm
Vodka Drinker
Posts: 6,920
Posts Per Day: 2.30
Reputation: 67.55%
Rep Score: +34 / -18
Approval: +3,429
Gold Stars: 115
Clicked on upmerob -saw a very "funny" if that's the word, video
Logged Offline
Private Message
1
0
0
 Reply: 15 - 23
Henryscat
October 20, 2018, 1:35pm
Fine Wine Drinker
Posts: 1,207
Posts Per Day: 0.23
Reputation: 86.91%
Rep Score: +5 / 0
Approval: +1,395
Non footy? 😜


Panic on the streets of Carlisle, Dublin, Dundee, Humberside
Logged Offline
Private Message
5
0
0
 Reply: 16 - 23
wigworld
October 20, 2018, 5:07pm

Whiskey Drinker
Posts: 3,126
Posts Per Day: 0.58
Reputation: 89.01%
Rep Score: +32 / -3
Approval: +2,080
Gold Stars: 29
Quoted from Mallyner


Was this the code Russell Slade was demonstrating at the forum?  


Give Rob some time. "He's building something".  
Logged Offline
Private Message Skype
5
0
0
 Reply: 17 - 23
Mallyner
October 20, 2018, 8:59pm
Cocktail Drinker
Posts: 1,788
Posts Per Day: 0.60
Reputation: 80.9%
Rep Score: +9 / -2
Location: New Waltham
Approval: +2,515
Gold Stars: 23
Quoted from wigworld


Give Rob some time. "He's building something".  



Shut up.  


Supporting Town for 65 years.  
Logged Offline
Private Message
2
1
0
 Reply: 18 - 23
KingstonMariner
October 20, 2018, 10:50pm
Meths Drinker
Posts: 22,096
Posts Per Day: 6.07
Reputation: 79.33%
Rep Score: +42 / -11
Approval: +23,440
Gold Stars: 218
Quoted from Mallyner


Shut up.  


Don't tell wig world to shut up. His car cost £80,000.


Through the door there came familiar laughter,
I saw your face and heard you call my name.
Oh my friend we're older but no wiser,
For in our hearts the dreams are still the same.
Logged Offline
Private Message
4
1
0
 Reply: 19 - 23
Mallyner
October 21, 2018, 1:28pm
Cocktail Drinker
Posts: 1,788
Posts Per Day: 0.60
Reputation: 80.9%
Rep Score: +9 / -2
Location: New Waltham
Approval: +2,515
Gold Stars: 23
Quoted from KingstonMariner


Don't tell wig world to shut up. His car cost £80,000.


I used to have a car like that,  a 15 year old Citroen Picasso I bought for £550.  


Supporting Town for 65 years.  
Logged Offline
Private Message
0
0
0
 Reply: 20 - 23
FishOutOfWater
October 22, 2018, 1:42pm
Barley Wine Drinker
Posts: 12,832
Posts Per Day: 2.14
Reputation: 87.01%
Rep Score: +52 / -7
Location: Goole
Approval: +6,573
Gold Stars: 37
Quoted from Mallyner


I used to have a car like that,  a 15 year old Citroen Picasso I bought for £550.  


Must have been a fake Mallyner… I'm sure original Picassos go for megabucks!  
Logged Offline
Private Message Skype
3
0
0
 Reply: 21 - 23
Mallyner
October 23, 2018, 10:58am
Cocktail Drinker
Posts: 1,788
Posts Per Day: 0.60
Reputation: 80.9%
Rep Score: +9 / -2
Location: New Waltham
Approval: +2,515
Gold Stars: 23
Quoted from FishOutOfWater


Must have been a fake Mallyner… I'm sure original Picassos go for megabucks!  


Very good.

Sadly as well as costing me a fortune, it was no oil painting.  


Supporting Town for 65 years.  
Logged Offline
Private Message
2
1
0
 Reply: 22 - 23
Civvy at last
October 23, 2018, 12:51pm

Barley Wine Drinker
Posts: 11,467
Posts Per Day: 2.04
Reputation: 74.47%
Rep Score: +36 / -13
Approval: +12,204
Gold Stars: 131
Quoted from Mallyner




Sadly as well as costing me a fortune, it was no oil painting.  



Sounds very much like my ex !!


The wife was going away for a girly weekend.
I jokingly remarked  'I don't know whether to spend it watching porn or watching football'
'you may as well spend it watching porn' she replied
That's understanding darling what makes you say that? I asked

She said 'Well you already know how to play football'  
Logged Offline
Private Message
2
1
0
 Reply: 23 - 23
3 Pages 1 2 3 All Recommend Thread
Print

Fishy Forum › Fishy Boards › Archive › Site speed

Back to top of page

This is not an official forum of Grimsby Town Football Club, the opinions expressed are those of the individual authors. If you see an offensive post then click "Report" on the relevant post. Posts will be deleted at the discretion of the moderators whose decision is final. Posts should abide by the Forum Rules. IP addresses of contributors together with dates and times of access are stored. The opinions and viewpoints expressed by contributors to The Fishy are their own and not necessarily those of The Fishy. The Fishy makes no claims that information dispersed through this forum is accurate or reliable. Also The Fishy cannot be held liable for any statements made by contributors of The Fishy.