[sqlite] Async I/O not working for me on v 3.8.5

[Tom]

Test code follows. The update query takes 3 seconds with or without the
async code.
Any ideas?


void Async_Thread() 
{
        sqlite3async_run();
}

//-------------------------------------------------------------------------------------
void CDatabase::Init(void)
{
        int rc = 0;
        
        rc = sqlite3_open("game.db", &PDB);
        FUN_ASSERT(rc == SQLITE_OK);
        FUN_ASSERT(PDB != NULL);

        rc = sqlite3async_initialize(NULL, 1);
        FUN_ASSERT(rc == SQLITE_OK);

        std::thread t(Async_Thread);

        char query_string[1024] = "";
        ::_snprintf_s(query_string, _countof(query_string), "UPDATE players SET
VotesUpdateDate = CURRENT_DATE;");

        LOG(L"Executing...\n");
        rc = sqlite3_exec(PDB, query_string, NULL, NULL, NULL);
        FUN_ASSERT(rc == SQLITE_OK);
        LOG(L"Done\n");

        sqlite3async_control(SQLITEASYNC_HALT, SQLITEASYNC_HALT_IDLE);
        t.join();
        sqlite3async_shutdown();

        rc = sqlite3_close(PDB);
        FUN_ASSERT(rc == SQLITE_OK);
        PDB = NULL;




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Async-I-O-not-working-for-me-on-v-3-8-5-tp76920.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users