I have an SQL command that insert data into a table by joining data from several tables. The command started working at 13:25:05 on 2018-01-14. And now, 15:56 on 2018-01-15, it's still not yet finished. I checked if there are any change with the database file but my database file
production.db and the journal file
production.db-journal have no update since yesterday as below
4608 Jan 14 13:25 production.db-journal
135711874048 Jan 14 17:41 production.db
Similar SQL statement was done before with the same target table but different number of joined tables. Last time, it took around 3 hours for the operation. And this time I expected it to take around 4 hours. But now, it's almost a day.
Does anyone know how to see if SQLite is still working or it's already crash?