Zeoslib Portal

Take a look at http://rahsoft.blogspot.se/2012/08/delp ... -zeos.html

When using Lazarus 1.2.0 and ZEOSLIB 7.2.0-alfa latest from svn and TZConnection and TZQuery I get Error in ZDbcOracleUtils row 789 and ORA-01460, "unimplemented or unreasonable conversion requested" When using a number in string (qry.ParamByName('dinrar').asString := '2010';) This works p...

Found the problem, it was the combination of setting AutoCommit and TransactIsolationLevel that fixed the speed, the Properties suggestion was irrelevant. ZConnection1.AutoCommit := False; ZConnection1.TransactIsolationLevel:= tiReadCommitted; I needed to add ZDbcIntfs to my uses in Lazarus to set T...

duplicate

Not as easy as it looks, I am still struggling! Here is how I have implemented your advice: ZConnection1.AutoCommit := False; ZConnection1.Properties.Add('synchronous=0'); ZConnection1.Properties.Add('locking_mode=EXCLUSIVE'); // 1 minute 23 sec for 555 rows sqlite // 1 sec for 555 rows firebird Wha...

I am using TZConnection and TZQuery to load about 50000 records into a table. If I use Protocol := ‘sqlite-3’ it takes over an hour, but if I use Protocol := ‘firebird-2.5’ it is less then a minute. I have used the default settings. How can I improve the insert speed for sqlite? I have read that I s...