Xailer & OZ Software

Hello Xailers,
We are receiving constant GPF error after many DBlocked errors.
e.g.: We are testing a insert/update routine that takes about 3 minutes to finish, on the meantime we are trying to execute some select or inserts, thats when the dblocked happens, also some times the operation just freezes, needing to force close the program...
Is there any error? or is there a way to lock only the table?

TIA,
Juliano

Attached files

emeasoft escribió el jue, 02 abril 2015 14:49Hello Xailers,
We are receiving constant GPF error after many DBlocked errors.
e.g.: We are testing a insert/update routine that takes about 3 minutes to finish, on the meantime we are trying to execute some select or inserts, thats when the dblocked happens, also some times the operation just freezes, needing to force close the program...
Is there any error? or is there a way to lock only the table?

TIA,
Juliano
Hello,
I'm really impressed about the time you routines lasts. If you are not using transactions I highly recommend them. BTW, SQLite is perfect for stand alone applications but when there is concurrent use of the database you should change to other engines like MariaDB.
I suggest you use exclusive transactions to completely block your database during that long process. I believe there is no way to lock only one table, but maybe I'm wrong.
Best regards,

Hello Ignacio,
It took so long because it was about 300000 inserts/update.
The good side of sqlite is that it does not need any installation, but we are going to study mariaDB instead, as you suggested, since we need concurrent users...
Many thanks for the help!
Juliano

emeasoft escribió el mié, 08 abril 2015 14:07Hello Ignacio,
It took so long because it was about 300000 inserts/update.
The good side of sqlite is that it does not need any installation, but we are going to study mariaDB instead, as you suggested, since we need concurrent users...
Many thanks for the help!
Juliano
I suggest you create a new empty LOCAL database for that bulk insert operation, create the table and insert all the records with a single transaction. Afterwards, ATTACH the local database to the target database and use a single INSERT FROM SELECT operation.
Regards,

Oh, Now I understand!
Thanks for the suggestion Ignacio, we will study that as well.
Regards,
Juliano