Slow rendering with shape files linked to csv

[AgAssist]

What is the bug or the crash?

I have a polygon layer (shape file) with around 100 polygons (farm paddocks) and I have linked this to a csv. I have styles set up which color code and label the paddocks based on soil test data within the csv. The csv files can be anywhere from 20kb to 200kb. when I go to make a change o the style for example the font size, the rendering is very slow. Sometimes it becomes unresponsive and eventually I have to restart QGIS. It worked well for years but seem to happen with a QGIS upgrade a year ago.
The problem does not occur when the link between the shape file and csv is deleted.

Steps to reproduce the issue

Change font size in style.
Wait for 2 to 3 minute for rendering to finish.

Versions

QGIS version
3.28.6-Firenze
QGIS code revision
868c9fa
Qt version
5.15.3
Python version
3.9.5
GDAL/OGR version
3.6.4
PROJ version
9.2.0
EPSG Registry database version
v10.082 (2023-02-06)
GEOS version
3.11.2-CAPI-1.17.2
SQLite version
3.41.1
PDAL version
2.5.2
PostgreSQL client version
unknown
SpatiaLite version
5.0.1
QWT version
6.1.6
QScintilla2 version
2.13.1
OS version
Windows 10 Version 2009

Active Python plugins
AnotherDXF2Shape
1.2.7
autoSaver
2.6
DirectionalSlope
1.3.2
dissolve_adjacent_polygons
0.1
lines_around_point
0.1
mask
1.10.2
MultiDistanceBuffer
3.2.4
Multi_Ring_Buffer
1.1
pointsamplingtool
0.5.4
profiletool
4.2.5
qchainage
3.0.1
Qgis2threejs
2.7.1
QGISSortAndNumber-master
1.0
QPackage
1.5
quick_map_services
0.19.33
SpreadsheetLayers
2.1.0
db_manager
0.1.20
MetaSearch
0.3.6
processing
2.12.99

Supported QGIS version

• I'm running a supported QGIS version according to the roadmap.

New profile

• I tried with a new QGIS profile

Additional context

I would be happy to share my screen via zoom or teams to demonstrate the issue

[agiudiceandrea]

@AgAssist have you actually tried creating and using a new QGIS user profile without additional external plugins? Could you please specify how exactly do you import the csv table in QGIS?

[AgAssist]

Hello Andrea, I tried creating a new profile but the issue keeps persisting. To import the csv I simply add it as a text delimited layer (Cntrl+Shift+T) with no geometry. ***@***.*** Within the shape file layer properties I then join the csv. ***@***.*** I hope this gives explains it a bit more. Regards, Luke From: Andrea Giudiceandrea ***@***.***> Sent: Tuesday, May 16, 2023 6:07 PM To: qgis/QGIS ***@***.***> Cc: Luke Taylor ***@***.***>; Mention ***@***.***> Subject: Re: [qgis/QGIS] Slow rendering with shape files linked to csv (Issue #53101) @AgAssist<https://github.com/AgAssist> have you actually tried creating and using a new QGIS user profile without additional external plugins? Could you please specify how exactly do you import the csv table in QGIS? — Reply to this email directly, view it on GitHub<#53101 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AESBPQERODVE3OP7WRUHNMTXGMYRFANCNFSM6AAAAAAYBS6USE>. You are receiving this because you were mentioned.Message ID: ***@***.******@***.***>>

[nicogodet]

@AgAssist Please answer on github directly instead of mail if you intend to join photos/screen capture or attachments.

Any way, If your remove the join, is it still slow ?

[AgAssist]

When the link is removed the rendering i dramatically improved.

With the link in place I tried "cache join in memory" on and off with no improvement on either scenario.

[nicogodet]

I could be a limitation of Delimited text provider.

Can you share sample data ?

[AgAssist]

Clearsprings Consolidated Soil Test Data.csv

[AgAssist]

Here is the shape file that it is linked to if that is any help. I have also saved the layer definition file which has all of the styles.
Clearsprings Paddocks.zip
Paddocks with Nutrient Styles.zip

[AgAssist]

I have tried saving the delimited text in a number of csv formats with no luck