Zeoslib Portal

Hi Everyone, I have an FPC / Lazarus application that frequently inserts data into a SQLite3 database. I have noted that when running threads that inserts the data into the database, memory usage of the application increases significantly, but when not executing the queries, memory usage remains sta...

Hi Everyone, I have a quick question on the CachedUpdates property that can be set to true on a Query. What does this property do? Does it: 1) Cache any updates made to the dataset and does not write the changes to records to disk until ApplyUpdates is called. This means all changes / updates to dat...

Hi Everyone, I have been searching for this for some time now and am not able to find any solution. Does anyone have any idea how I can copy / duplicate one dataset from one to the other? (TZQuery decendant) If I try: dataset1 := dataset2 it works until I close dataset2, which then also closes datas...

Hi again everyone. How do I insert data into a dataset that already exists in the same database. Basically, say I populate my dataset with some (not all) of the data in the table. Now I want to add some data to the dataset that already exists in the table - how do I go about inserting this without c...

Hi Everyone, I am new to SQLite and ZeosLib and have ended up here in my attempt to speedup SQLite3 insert queries. After reading a bit I found that if I set the synchronous mode of SQLite to 'off', the insert queries should be 50 times faster. Wanting to test this, I wrote the following small appli...