projects / psqlodbc.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5b7ec37) | patch
Make SQLSetPos(SQL_DELETE/SQL_REFRESH) more effective.
authorHiroshi Inoue <h-inoue@dream.email.ne.jp>
Tue, 27 Mar 2018 02:08:42 +0000 (11:08 +0900)
committerHiroshi Inoue <h-inoue@dream.email.ne.jp>
Tue, 27 Mar 2018 02:08:42 +0000 (11:08 +0900)
commit1418f70b2d8768401ad9d3a88aaba2941debaf23
treef4aa2f5af9065e47e77a001ee63a34c9bda8da6dtree
parent5b7ec37b43a0aef0e75dfae80901c456b0f5760ecommit | diff
Make SQLSetPos(SQL_DELETE/SQL_REFRESH) more effective.
Because queries calling currtid(2) like
select .. from .. where ctid=currtid2(.., ..)
cause Seq Scan, their execution may be very slow.
It is better to execute queries using subqueries like
select .. from .. where ctid=(select currtid2(.., ..))
because they cause Tid Scan.
Report and changes by Tsunakawa Takayuki.
results.c diff | blob | blame | history
Official repository of the psqlodbc driver.