CarpForum.co.uk brand mark, a blue stylized fish with a white eye and a smooth modern look, set in the site header against a clean background CarpForum.co.uk wordmark in a bold flowing script style, reading CarpForum.co.uk, displayed in the site header
Menu
Utils
Go Premium Who's Online Members Weather Photo Gallery Articles
Account
Login
Forum reply delays, hanging. (30 posts / 9,351 views)
vossy1 vossy1
MODERATOR
Posts: 9,008
#16 16 May 2024 18:00
1
Defo on a bit of a slow 1745 to now, 1800, also this avo but I didnt note the time, few dps about
Karlos Karlos
MODERATOR
Posts: 14,136
#17 17 May 2024 02:26
0
In reply to Post #16
I was hoping I had fixed it the other night :(
When looking for problems, I found a table in the database with 29 million records in it. The housekeeping hadn't been running.
I manually cleared it down to a more sensible 1.5million records, so it should be faster

The delays seem to be posting a message or a PM.

Still looking into it...
vossy1 vossy1
MODERATOR
Posts: 9,008
#18 17 May 2024 13:20
0
In reply to Post #17
When looking for problems, I found a table in the database with 29 million records in it. The housekeeping hadn't been running.
I manually cleared it down to a more sensible 1.5million records, so it should be faster

I'm not sure which figire scares me more, or the fact you did some manually
vossy1 vossy1
MODERATOR
Posts: 9,008
#19 17 May 2024 20:07
0
7 second delay submit to post just now 20.07 (home wifi), 5 sec before (mobile date).
Karlos Karlos
MODERATOR
Posts: 14,136
#20 17 May 2024 23:45
0
In reply to Post #19
Thanks.
vossy1 vossy1
MODERATOR
Posts: 9,008
#21 18 May 2024 08:51
0
In reply to Post #20
7 sec again 0851 18/05/24
But this msg faster, more like 2 or 3, so o.k

1057, same 7 seconds posting and 1059 loading a page.

Karlos Karlos
MODERATOR
Posts: 14,136
#22 27 May 2024 23:16
1
In reply to Post #21
I had an idea what it might be, just made a tweak to the code.
Let's see if this post happens fast or slow....drumroll...

Result: Very fast. Hopefully that's the bottleneck sorted...but I'm not counting my chickens just yet
vossy1 vossy1
MODERATOR
Posts: 9,008
#23 28 May 2024 07:17
0
In reply to Post #22
Fingers crossed , thank you
Karlos Karlos
MODERATOR
Posts: 14,136
#24 29 May 2024 02:34
2
In reply to Post #23
Last night I went through every new post (and thread) and tried to delete all the duplicate posts.
Tonight, I have gone through them all checking, and haven't found any new posts which are duplicates.

Smug mode on...

I have also now tweaked the Send PM code, as sending a PM was taking a while (and I have been getting a few repeats where people click Send more than once)

PMs now send faster

Good night
vossy1 vossy1
MODERATOR
Posts: 9,008
#25 29 May 2024 06:54
1
That's dedication
All seems a lot more fluid now
Ynnek
Posts: 887
#26 29 May 2024 21:19
0
In reply to Post #24
Hi Karlos,

I've got a PM but can't open it. It get loaded, takes a while and then it spits an ‘error message' .

Anything you can do about it?
Karlos Karlos
MODERATOR
Posts: 14,136
#27 29 May 2024 21:20
0
In reply to Post #26
I will take a look in when I get back indoors later...
Darkieallard
Posts: 4,935
#28 29 May 2024 21:21
0
In reply to Post #26
I'm the same.
Karlos Karlos
MODERATOR
Posts: 14,136
#29 29 May 2024 22:10
0
Apologies, bug by me.
Fixed it now though
Ynnek
Posts: 887
#30 30 May 2024 19:51
0
In reply to Post #29
Thanks.
It's fixed indeed
Are you sure?

This action cannot be undone.

Yes, continue

Loading…