Hi all,
I have to correct myself a little... the hanging sqlite3_open_v2() does
not happe while the prepare of the first query but during the first
sqlite3_step() of the first query...
So in pseudo code the database access looks like this:
first thread:
sqlite3_open_v2("log.sqlite", SQLITE_OPEN_READONLY |
SQLITE_OPEN_NOMUTEX, NULL);
sqlite3_exec(log_database_local, "PRAGMA read_uncommitted=True;", NULL,
0, &err)
sqlite3_prepare_v2(log_database_local, "select distinct xyz from log
where ...)
while(sqlite3_step(sql_stmt) == SQLITE_ROW)...
While every step takes _very_ long time as the log table has quite a lot
entries (> 5.000.000)
second thread:
sqlite3_open_v2("log.sqlite", SQLITE_OPEN_READONLY |
SQLITE_OPEN_NOMUTEX, NULL);
---> This sqlite3_open_v2 does not return until the prepare
sqlite3_step() statement of the first thread has completed...
again: Any help or short hint would be very appreciated!
Thanks in advance,
Ole Reinhardt
--
Thermotemp GmbH, Embedded-IT
Embedded Hard-/ Software and Open Source Development,
Integration and Consulting
http://www.embedded-it.de
Geschäftsstelle Siegen - Steinstraße 67 - D-57072 Siegen -
tel +49 (0)271 5513597, +49 (0)271-73681 - fax +49 (0)271 736 97
Hauptsitz - Hademarscher Weg 7 - 13503 Berlin
Tel +49 (0)30 4315205 - Fax +49 (0)30 43665002
Geschäftsführer: Jörg Friedrichs, Ole Reinhardt
Handelsregister Berlin Charlottenburg HRB 45978 UstID DE 156329280
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
