I have the huge size of the database file (approx 5.5GB).
I have two processes.
1.The first process:
It executes master table query. (Ex. "SELECT "type", "tbl_name" FROM
"SQLite_MASTER").
It creates the new table using the dump of the existing table and database file
size has been increased after dump ( approx 5.7 GB).
For Example:
SQL Statement: "CREATE TABLE "XYZ" AS SELECT * FROM ABC "
2. The second process:
It deletes tables which have been created by the first process.
delete query takes 4 minutes.
I have tested the three test scenario.
1. The first scenario : database is locked when I have executed "SELECT "type",
"tbl_name" FROM "SQLite_MASTER"".
The first process execution is completed.
The second process starts and it is still running.
I execute the first process while the second process is already running.
sqlite throw error: "SELECT "type", "tbl_name" FROM "SQLite_MASTER"" in the
first process.
2. The second scenario: database is locked when I have executed "CREATE TABLE
XYZ AS SELECT "name" FROM "ABC".
The first process execution is completed.
The second process starts and it is still running.
I execute the first process while the second process is already running.
In the case of master table query executed successfully ("SELECT "type",
"tbl_name" FROM "SQLite_MASTER"").
sqlite throw error: "CREATE TABLE XYZ AS SELECT "name" FROM "TEST"" in the
first process.
3. The third scenario: There is no error.
The first process execution is completed.
The second process starts and it is still running.
I will wait for the end of execution of the second process.
After that, I start the first process for execution.
There is no error when we are execute two processes one by one.
I want to run the second process in the background.
Execute first process
Execute the second process as soon as first is executed.
While the second process is running, I want to start the first process.
I cannot combine first and second process because deleting take 4 minutes and
my application gets busy.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
