Print Topic - Archive
Fishy Forum / Archive /
Posted by: GrimRob, October 19, 2018, 9:16pm
I know the site has been slow today. I have identified the problem and am hoping for a fix soon.
Apologies for the slowness.
Posted by: promotion plaice, October 19, 2018, 9:25pm; Reply: 1
Yeah ....it's painfully slow for me at the moment.
Posted by: golfer, October 19, 2018, 9:26pm; Reply: 2
Fcook me-it's that slow I didn't know the Mansfield game was postponed
Posted by: GrimRob, October 19, 2018, 9:39pm; Reply: 3
Any better? I killed off some rogue connections
Posted by: promotion plaice, October 19, 2018, 9:44pm; Reply: 4
Any better? I killed off some rogue connections
Miles better for me now Rob :)
Posted by: GrimRob, October 19, 2018, 9:47pm; Reply: 5
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.
Posted by: LH, October 19, 2018, 10:01pm; Reply: 6
Any better? I killed off some rogue connections
What were their usernames?
Posted by: fishyfanny, October 19, 2018, 10:14pm; Reply: 7
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😏
Posted by: GrimRob, October 19, 2018, 10:17pm; Reply: 8
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.
Posted by: lew chaterleys lover, October 19, 2018, 10:50pm; Reply: 9
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.
Posted by: denni266, October 19, 2018, 10:59pm; Reply: 10
Posted by: KingstonMariner, October 19, 2018, 11:00pm; Reply: 11
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.
Posted by: GYinScuntland, October 20, 2018, 1:19am; Reply: 12
It's so slow it's tomorrow.
Posted by: Mallyner, October 20, 2018, 8:08am; Reply: 13
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? :)
Posted by: GrimRob, October 20, 2018, 11:48am; Reply: 14
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/779680064UPDATE: Phase 2 is now done
Posted by: golfer, October 20, 2018, 12:26pm; Reply: 15
Clicked on upmerob -saw a very "funny" if that's the word, video
Posted by: Henryscat, October 20, 2018, 1:35pm; Reply: 16
Posted by: wigworld, October 20, 2018, 5:07pm; Reply: 17
Was this the code Russell Slade was demonstrating at the forum? :)
Give Rob some time. "He's building something". ;D
Posted by: Mallyner, October 20, 2018, 8:59pm; Reply: 18
Give Rob some time. "He's building something". ;D
Shut up. :)
Posted by: KingstonMariner, October 20, 2018, 10:50pm; Reply: 19
Shut up. :)
Don't tell wig world to shut up. His car cost £80,000.
Posted by: Mallyner, October 21, 2018, 1:28pm; Reply: 20
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. :)
Posted by: FishOutOfWater, October 22, 2018, 1:42pm; Reply: 21
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! ;)
Posted by: Mallyner, October 23, 2018, 10:58am; Reply: 22
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. :)
Posted by: Civvy at last, October 23, 2018, 12:51pm; Reply: 23
Sadly as well as costing me a fortune, it was no oil painting. :)
Sounds very much like my ex !!
Print page generated: May 3, 2024, 9:10pm