Extremely Low performance with ODBC
От | Sebastian Rychter |
---|---|
Тема | Extremely Low performance with ODBC |
Дата | |
Msg-id | 004301c8bc39$c43aba40$4cb02ec0$@com.ar обсуждение исходный текст |
Ответы |
Re: Extremely Low performance with ODBC
Re: Extremely Low performance with ODBC Re: Extremely Low performance with ODBC |
Список | pgsql-sql |
<div class="Section1"><p class="MsoNormal"><span lang="EN-US">Hi, I’m executing a query through psql ODBC which is takingaround 2 minutes to complete. When I run it from PgAdmin it takes less than 3 seconds.</span><p class="MsoNormal"><spanlang="EN-US">The query itself has :</span><p class="MsoNormal"><span lang="EN-US">. 15 inner joins(from just around 10 different tables – the other inner joins are using different aliases for the same tables) </span><pclass="MsoNormal"><span lang="EN-US">. Select statement returns 1 field.</span><p class="MsoNormal"><span lang="EN-US">.the testing database is selecting only 1 record.</span><p class="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><spanlang="EN-US">Taking a look at the explain analyze report, I see they are both quite the same and testedthe ODBC driver through Visual Foxpro and Vb.NET as well, taking both around 2 minutes to finish.</span><p class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Any idea ?</span><p class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Thanks,</span><p class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Sebastian</span></div>
В списке pgsql-sql по дате отправления: