[sqlite] Is there schema caching in sqlite?

I have a multi-threaded application. Each thread has its own database connection. One of the thread changes the schema of the database (DROP TABLE, CREATE TABLE). I have observed that the other threads do not know about these modifications since queries for the new/altered table doesn't return

Re: [sqlite] Thread handling in Windows

Every Windows DLL can provide a DllMain function. This function gets called whenever a thread gets created or destroyed. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dllproc/base/dllmain.asp Some example code: /** \brief */ BOOL WINAPI DllMain( HINSTANCE hinstDLL,

[sqlite] Tuning a SELECT DISTINCT query?

Hi all, I have a performance issue with the following query: SELECT DISTINCT name FROM customproperty ORDER BY name; The table and an index is defined by: CREATE TABLE customproperty (parentID INTEGER NOT NULL, name VARCHAR(100) NOT NULL,