Sample Header Ad - 728x90

SQL fast in PSQL, very slow using MS.NET driver

0 votes
0 answers
151 views
There's thread with exact same title and problem, but with no answer, NPGSQL driver takes very long time to execute queries, but other language drivers or terminal works fine. From what I've found, it's related to parameter sniffing in other SQL databases, but I could not find much for Postgres. I'm running UPDATE statement, so it doesn't return many rows. .NET Core 3.0, NPGSQL 4.1.1, PostgreSQL 10.9 (Ubuntu)
Asked by iNeedHealing255 (1 rep)
Oct 25, 2019, 06:49 AM
Last activity: Oct 25, 2019, 09:33 AM