Zeoslib Portal

I'm so sorry. I apologize for not answering your questions and for not including in the test code the configuration you have recommended. How did you insert those records? Query1.SQL.Text:= 'INSERT INTO tb_test_zeos (ID) VALUES (:PARAM_ID)'; For Id:= 1 To Records Do Begin Query1.ParamByName('PARAM_I...

@ EsequiasTorres2, I do not understand why this is happening? Maybe change the server? For me it is so (in your test): Server info = 5.5.5-10.1.1-MariaDB Client info = 5.5.40 Delphi 10 Seattle -Win32(on Win 10-64) Zeoslib 7.3.0-alpha svn 5355 Insert data, do not use prepared sql statement 49031 Mil...

I've done a little test and I find that something is wrong. CREATE DATABASE "dbtestzeos" /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_spanish_ci */; USE "dbtestzeos"; CREATE TABLE "tb_test_zeos" ( "ID" mediumint(8) unsigned NOT NULL default '0', PRIMARY KE...

@EsequiasTorres, Hi and welcome to Zeos! According the inserts: How did you insert those records? I mean you'd say: If I use prepared queries as you have suggested it takes 11 seconds to insert the 100,000 numbers, less time than MyDAC. I want to know how you did that. On 7.3 i've optimized the pre...