[Qgis-user] Qgis Form // Attached tool / Big performance problem for table opening

[Tobias Schula]

Am 05.10.25 um 20:18 schrieb celati Laurent via QGIS-User:

 > I work with Windows with Qgis 3.34.13-Prizren.
 > I have a Qgis project destined to be shipped on a tablet for the field
 > (Qfield).
 > The project contains a polygonal layer of 3427 objects (file shp). There
 > are many columns with different types. There also relational values / 
joins
 > setted for this form. So the project also includes .csv files (for
 > relational values).

Have you tried putting all the data into a database? For example a 
single geopackage file? Reading CSV is slower than from SQLite. 
Geopackage is an SQLite database.

 > The problem : the opening of this table attribute takes up to 40 
seconds. I
 > spent time to identify where the problem may come from. At one time I
 > thought for joins/relational values. Or also CSV format. As we can 
see here
 > :
 > 
https://gis.stackexchange.com/questions/423054/what-is-slowing-qgis-the-most-when-opening-form
 >
 > After several hours of investigation, the source of the problem seems to
 > come from 4 columns (string) for strore the pictures. After removing 
those
 > 4 columns of the form, the opening time of the table become normal.
 > I have tried to "play" with the parameter for this form attached 
tool, (as
 > for example relative/absolute path size of the images, etc.). But in 
vain.
Are you storing the picture in a separate table? For pictures, this is 
the approach QField recommends: https://docs.qfield.org/how-to/pictures/
-- 
Tobias A Schula
Forestry Expert

geospatial at schula.org

-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_0x3B6BA2B3E91776FA.asc
Type: application/pgp-keys
Size: 3126 bytes
Desc: OpenPGP public key
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20251008/e5360a09/attachment.key>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature.asc
Type: application/pgp-signature
Size: 840 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20251008/e5360a09/attachment.sig>