<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Hi Rémi,<br>
<br>
During the provider creation, a lot of SQL requests are made to
check a lot of thing even if the use estimated metadata is checked :<br>
* Fields list<br>
* geometry type<br>
* primary key<br>
* extent<br>
* capabilities (read, insert, update, delete)<br>
<br>
You can take a look at these PRs to have an idea on all the SQL
request made at the creation :<br>
* <a class="moz-txt-link-freetext" href="https://github.com/qgis/QGIS/pull/49440">https://github.com/qgis/QGIS/pull/49440</a><br>
* <a class="moz-txt-link-freetext" href="https://github.com/qgis/QGIS/pull/50186">https://github.com/qgis/QGIS/pull/50186</a><br>
<br>
Regards,<br>
René-Luc<br>
<br>
<div class="moz-cite-prefix">Le 16/11/2022 à 09:55, Julien Cabieces
via QGIS-Developer a écrit :<br>
</div>
<blockquote type="cite" cite="mid:87o7t7xor2.fsf@julien-laptop.home">
<pre class="moz-quote-pre" wrap="">
Hi Remi,
Which profiler are you talking about ?
Did you try to use the the new Debugging/Developement tool ? It's new
since QGIS 3.26 and will give you the list of requests and the time
spent for each one when loading a project/layer or opening the attribute
table.
Regards,
Julien
</pre>
</blockquote>
<br>
<div id="grammalecte_menu_main_button_shadow_host" style="width:
0px; height: 0px;"></div>
</body>
</html>