I am using an SQLlite database and calling all my queries synchronously. All, but one of the queries is fast, so I was wondering if I could call that one query asynchronously. I created two sqlConnections, one called sync and another async. After making the asynchronous call, I called a synchronous query and got this error:
SQLError: 'Error #3119: Database file is currently locked.', details:'', operation:'execute'
Do asynchronous queries always lock the database? Is it not possible to call more than one query at a time? How does this work for all asynchronous calls? Are the queries queued up and called one at a time?