Zeoslib Portal

trupka: thank you very much! Could you tell me how to set "pragma autovacuum = 1|" of sqlite3 with Zeos ?

sqlite3

Hi, friend!
I added 1k records in the test table, and then I delete the records. I found the file size of db did not decrease.

Could you tell me how to make the "auto-vacuum" work ? Thanks!

trupka: thank you very much! it takes about 1 second at most now, so amazed!

Hi, friend! My function is to insert about 400 sentences, and it takes about 20 seconds in the execution. Could you tell me the problems ? function ExecSQL: Boolean; var ZQuery: TZQuery; begin Result := True; ZQuery := TZQuery.Create(nil); try try ZConn.StartTransaction; ZQuery.Connection := ZConn; ...