How to improve the speed of TSQLconecctor? (Postgres)
lazarus / 16-Databases

----------------------------------------------------------------------
cpalx · 2014-07-31 18:01

Lazarus 1.2.4
FPC 2.6.4
Tested: Windows/Linux

I changed Zeos 7.1.3 to TSQLconnector

The application makes a remote server conection, every Query, Insert,
Update works, but there is one special problem:
With the same Server, Database; the same client and same Internet
speed (so slow 1.0Mb at 15%)
the application compiled with Zeos open a window with several query in
4s and the application compiled with TSQLconector open the same window
in 21s.

i know i can improve the querys  making a Store Procedure, but the
question is how make it work at the same speed

Transaction in TSQLconector has caCommitRetaining, because i need to
see other querys that are displaying in a DBgrid.

additonal information: the Window make 6 sequencial querys in the
OnFormShow event.

 I will thank any help

--
Christian

----------------------------------------------------------------------
goodname · 2014-08-02 16:41

I would guess that this had to do with transaction handling. Try
changing the Zeos transaction settings and see what happens.
http://www.freepascal.org/docs-
html/fcl/sqldb/tsqltransaction.action.html

----------------------------------------------------------------------
cpalx · 2014-08-04 17:22

but Zeos is not the problem, the problem is with TSQLconector

----------------------------------------------------------------------
goodname · 2014-08-04 17:37

Yes but setting TSQLTransaction.action does nothing in SQLdb. There is
always an open transaction for all open queries in SQLdb. If you can
show that the performance difference is due to transaction handling
then there would be a motivation to improve it. The best way that I
can think of showing this is to get Zeos to perform as poorly and the
only difference being transaction handling.

Addition: Manually calling CommitRetaining after opening the select
queries in the OnFormShow event may simulate the caCommitRetaining
setting.