Zeoslib Portal

If any of you can please execute the following code and show the result would be of great help to me. SQL: "select ID from tb_test_zeos" to select 100,000 numbers procedure TForm1.Button1Click(Sender: TObject); var li: integer; st, st1: cardinal; begin ZConnection1.Disconnect; ZConnection1...

Hello EsequiasTorres, Zeos 7.3 most probably will contain new performance enhancements for MySQL. But one more thought on 7.2: I seem to remember that Zeos always uses prepared staments. In a case like that using your code could become a performance killer because it needs to be prepared again and ...

@EsequiasTorres, It is possible that the MyDAC opens only the initial records. Can you give the results of such a test ?: SQL: "select ID from tb_test_zeos" procedure TForm1.Button1Click(Sender: TObject); var li:integer; st,st1: cardinal; begin ZConnection1.Disconnect; ZConnection1.Connec...

Don't know about MyDAC but Zeos uses automatic transaction control by default. Try switching to manual control and perform all your of loop inside a single transaction. I believe it will significantly increase perf. As for USE_SYNCOMMONS, it just enables one method to export dataset to JSON, it has...

I use Delphi 7 with MyDAC ( https://www.devart.com/mydac/ ) and I want to use Synopse mORMot Framework ( https://synopse.info/fossil/wiki?name=SQLite3+Framework ) with ZeosLib (7.2.4-stable build at 2018-03-25 11:08:27) to access MySQL databases (MySQL 5.0.18-nt), but in the tests I have found that ...

I am using the Synopse mORMot Framework (https://github.com/synopse/mORMot) and in the documentation ( https://synopse.info/files/html/Synopse%20mORMot%20Framework%20SAD%201.18.html#TITL_94 ) it is recommended to use ZEOS to access databases. I have downloaded the latest version of ZeosLib from http...

I am using the Synopse mORMot Framework (https://github.com/synopse/mORMot) and in the documentation ( https://synopse.info/files/html/Synopse%20mORMot%20Framework%20SAD%201.18.html#TITL_94 ) it is recommended to use ZEOS to access databases. I have downloaded the latest version of ZeosLib from http...