Joe Mistachkin wrote:
How was the native SQLite library compiled? Was it compiled with
SQLITE_THREADSAFE set to 1? Also see: https://www.sqlite.org/threadsafe.html
Compiled in Debian build proc I suppose with the default of 1. I am
trying to find the source file :)
I will try a few tests with only 1 thread allowed and let you know.
Only one thread at-a-time may safely use a SQLiteConnection object
instance; however, you can create one of these on each thread and open
the same database.
--
Built an app with 1 form, 1 button, 1 command etc no threading and put a
loop for inserting records and yep, same result so back to the drawing
board. Not quite given up yet because I want to continue using SQLite on
the app in windows and it would be great to get things going in Linux.
Settings in the test were
Dim connBuilder As New SQLiteConnectionStringBuilder
connBuilder.Version = 3
'Set page size to NTFS cluster size = 4096 bytes
connBuilder.PageSize = 4096
connBuilder.CacheSize = 20000
connBuilder.Pooling = True
connBuilder.LegacyFormat = True
connBuilder.DefaultTimeout = 1000
connBuilder.JournalMode = SQLiteJournalModeEnum.Delete
connBuilder.SyncMode = SynchronizationModes.Normal
connBuilder.FailIfMissing = True
Anyone know of any bugs with Mono 2.6 or debian 6 that could cause this
as it might be there rather than here I should be looking?
Cheers
--
..........................
Dave Edwards (G7RAU)
email:
d...@g7rau.co.uk
Web:
http://g7rau.demon.co.uk/
..........................
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users