mercredi 7 octobre 2015

How does Shared Cache work in SQLite?

I still can't get my head around this. I have a Application which runs multiple threads. Can someone enlighten me from the following scenario based question?

SCENARIO

  • Thread 1 opens an SQLite Database connection, queries it, and thus caches what it has read inside Server Memory. Thread 1 then Closes the connection
  • Then Thread 2 open the SQLite Database, performing almost similar query to Thread

QUESTION : Will thread 2 be able to access the cached data from Thread 1, ensuring a faster Query (eventhough Thread 1 has closed the connection)?

Aucun commentaire:

Enregistrer un commentaire