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