greetings from Switzerland

[flumsi]

Yes, Querys

Abfragen are queers right?
https://prnt.sc/86IWm78ZmxHB

In the debugging on the main page, the SQL query you mean, Steve? How can I save it as a file?

Send stoker a copy of the page from sql queens, he will find the problem!

[Steve]

Turn of the extension to start with this table name

Points table

Also your groups table and users table is the problem, an extension thats accessing them is doing it in a loop some where.

[flumsi]

Hello everyone

I've found the culprit. The following extension caused 124 queries.

Code: Select all

"name": "devspace/verifiedmember",
	"type": "phpbb-extension",
	"description": "An extension that adds the option to show members of a group as verified.",
	"version": "3.3.0",
	"time": "2022-11-18",
	"keywords": [
		"phpbb",
		"extension",
		"verified",
		"member"
	],
	"license": "GPL-2.0-only",
	"authors": [{
	 	"name": "devspace",
		"role": "Maintainer"
    },
	{
		"name": "David Wood (david63)",
		"role": "Developer"
	}],
	"require": {
        "php": ">=7.1.3",
        "composer/installers": "~1.0"
    },
	"extra": {
		"display-name": "[devspace] Verified member",
		"soft-require": {
			"phpbb/phpbb": ">=3.3.0,<4.0.0@dev"
		},
		"version-check": {
        	"host": "version.phpbbdev.space",
        	"directory": "/versions/devspace",
        	"filename": "verified_member_version_file.json",
			"ssl": true
    	}
	}
}

Screenshot 2025-06-25 215211.png

[Steve]

Mental. Speak too the developer and let them know.

[Stoker]

As a guest I still get: Ladezeit: 0.478s | Max. Speicherauslastung: 21.85 MiB | Abfragen: 505
The extreme count of queries is a red flag. Some of your extensions is probably lousy coded, most likely outdated.

Personally I would NEVER use an extension that causes much load or extra queries.
But again, if it works for you

[flumsi]

Strange, I get the following as a guest and as a registered member:

Loading time: 0.364s | Max. memory usage: 21.75 MiB | GZIP: Off | Queries: 78

I've cleared all caches. How can you still get 505 queries?
I've never bothered with queries until recently. I thought this was normal.

Now I've eliminated over 100 queries (extension devspace/verifiedmember), and no one in the guild could get more than 100 queries displayed. Newly registered members were also asked, and they got just under 100 because nothing was in the browser cache yet.

505 queries is a lot and impossible to reproduce. I get no more than 100 queries with every browser I've tested (Chrome, Firefox, Brave, Vivaldi, and a few more).

You had 573 queries, but after I deactivated the extension, You still have 503 queries. You're only missing 70 queries compared to before, but I lost 124 queries by deactivating the extension.

How is that possible?

[Steve]

Ladezeit: 0.493s | Max. Speicherauslastung: 21.86 MiB | Abfragen: 516

is what i see now in your debug info. try disabling the ` points extension`, then other extensions one by one.

[Stoker]

This is when im logged in: Ladezeit: 0.457s | Max. Speicherauslastung: 22.09 MiB | Abfragen: 525
and logged out: Ladezeit: 0.478s | Max. Speicherauslastung: 20.89 MiB | Abfragen: 506

As Steve suggest, disable extensions until you find the culprit

[flumsi]

I'm logged in and see

Loading time: 0.401s | Max. memory usage: 21.72 MiB | GZIP: Off | Queries: 81 | SQL Explain

I'm in the process of disabling one extension at a time.

Calendar results in 11 queries, but I need it.
Ultima Points results in 10 queries, but I need it.

Another 20 extensions disabled and a total of 10 fewer queries. This is going to be a real chore.

All my installed extensions are listed here in the imprint.
look

[Stoker]

I still get about 500 queries

You mention both points and calender. There is a hookup ext that goes with the calendar. Hookup and hjw calender was written for 3.1 correct?