Alexander, Just curious, how do you call Backup API from .NET (if you do)? AFAIK it's not accessible through System.Data.SQLite.dll. Did you have to compile SQLite separately from c sources?
Thank you, - Levi ----- Original Message ----- From: sqlite-users@sqlite.org To: sqlite-users@sqlite.org At: 3/15 11:10:21 Hello, I am using SQLite to keep a copy of a database in memory. On load, this database is read off disk with the Backup API. Our project is .Net and we are using the System.Data.Sqlite driver 1.0.75. I have been testing performance under load and noticed some strange behavior. Access to a single connection is synchronized and I saw 30 threads waiting on a thread with the stack trace below. Why would prepare be calling into backup? I am very confused, if anyone could shed some light on this I would be greatly appreaciative. 000000000b1ec888 000007fef8b6eab7 System_Data_SQLite+0x1270 000000000b1ec890 000007fef8bdc0a8 System_Data_SQLite!sqlite3_backup_remaining+0x107 000000000b1ec8f0 000007fef8be0329 System_Data_SQLite!sqlite3_backup_init_interop+0x84b8 000000000b1eca90 000007fef8be3b67 System_Data_SQLite!sqlite3_backup_init_interop+0xc739 000000000b1ecb00 000007fef8c05448 System_Data_SQLite!sqlite3_backup_finish+0xcf7 000000000b1ecb70 000007fef8c077cb System_Data_SQLite!sqlite3_prepare16_interop+0x5188 000000000b1ecd80 000007fef8c0799e System_Data_SQLite!sqlite3_prepare16_interop+0x750b 000000000b1ecdc0 000007fef766ff82 System_Data_SQLite!sqlite3_step+0x8e 000000000b1ecdf0 000007ff009ed042 mscorwks!DoNDirectCallWorker+0x62 000000000b1ece80 000007ff009ebae9 System_Data_SQLite!System.Data.SQLite.SQLite3.Step(System.Data.SQLite.SQLiteStatement)+0xa2 000000000b1ecf90 000007ff009eb935 System_Data_SQLite!System.Data.SQLite.SQLiteDataReader.NextResult()+0x159 000000000b1ecfd0 000007ff009eb2c4 System_Data_SQLite!System.Data.SQLite.SQLiteDataReader..ctor(System.Data.SQLite.SQLiteCommand, System.Data.CommandBehavior)+0x75 000000000b1ed020 000007ff013925da System_Data_SQLite!System.Data.SQLite.SQLiteCommand.ExecuteReader(System.Data.CommandBehavior)+0x34 Please NOTE: This electronic message, including any attachments, may include privileged, confidential and/or inside information owned by Demand Media, Inc. Any distribution or use of this communication by anyone other than the intended recipient(s) is strictly prohibited and may be unlawful. If you are not the intended recipient, please notify the sender by replying to this message and then delete it from your system. Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
