[Mono-dev] Mono.Data.Sqlite

2008-07-03 Thread Anders Aagaard
Hi I've been using Mono.Data.Sqlite in a multi threaded application, since the code says it's based on Robert Simpson's library I've been looking at his page for documentation (as Mono.Data.Sqlite documentation seems extremely sparse). My problem is that when using multiple threads, all writing

[Mono-dev] Mono.Data.Sqlite performance

2012-01-27 Thread David A Knight
I have been looking at changing an iOS app over to using Monotouch and run into an issue with Sqlite performance. Writing some test code (not running on a device) that just opens a database and does a number of inserts (in a transaction) the performance difference between C (using Core Foundati

Re: [Mono-dev] Mono.Data.Sqlite

2008-07-03 Thread Joe Audette
Hi, My impression is that SQLite is not that great a choice for a multi threaded app. If you google sqlite mutli threading, in the first result which links to here: http://www.sqlite.org/cvstrac/wiki?p=MultiThreading you'll see: "It has never been safe to use the same database connection simulta

Re: [Mono-dev] Mono.Data.Sqlite

2008-07-05 Thread [EMAIL PROTECTED]
Hi, Yes, we use sqlite for testing purposes (the memory backend). But unfortunately there's no way to use in in multithreaded environments. The only option would be locking the access, but it is dangerous and you could en up in deadlocks if you're not very careful. pablo Joe Audette escribi

Re: [Mono-dev] Mono.Data.Sqlite

2008-07-05 Thread Angel Marin
Anders Aagaard wrote: > Every thread has it's own cloned SqliteConnection (during the creation of > the thread I call MasterConnection.Clone (), and only use the referenced > connection). The exception happens instantly when two threads begin a > transaction to the same database. Last time I had

Re: [Mono-dev] Mono.Data.Sqlite

2008-07-14 Thread Ķaмȋļ ๏ Şκaļşκȋ
Still, you need to use separate connection for each thread - it should be a perfect use of http://en.wikipedia.org/wiki/Thread-local_storage#C.23_and_other_.NET_languages On Sat, Jul 5, 2008 at 12:34 PM, Angel Marin <[EMAIL PROTECTED]> wrote: > Anders Aagaard wrote: >> Every thread has it's own cl

[Mono-dev] Mono.Data.Sqlite and .Net

2011-10-22 Thread Vinícius Gobbo Antunes de Oliveira
Good afternoon, I'm working on a small command line project where Sqlite fits my needs. I'm using Visual Studio to develop. The project must work on Mac, Windows and Linux (and on mobile platforms, sometime in the future). On Windows, I'm using .Net 4.0 base assemblies, but I'm also trying to refe

Re: [Mono-dev] Mono.Data.Sqlite performance

2012-01-27 Thread Robert Jordan
On 27.01.2012 15:54, David A Knight wrote: I have been looking at changing an iOS app over to using Monotouch and run into an issue with Sqlite performance. Writing some test code (not running on a device) that just opens a database and does a number of inserts (in a transaction) the performance

Re: [Mono-dev] Mono.Data.Sqlite performance

2012-01-27 Thread David A Knight
On 27 Jan 2012, at 17:27, Robert Jordan wrote: > On 27.01.2012 15:54, David A Knight wrote: >> I have been looking at changing an iOS app over to using Monotouch >> and run into an issue with Sqlite performance. Writing some test >> code (not running on a device) that just opens a database and do

[Mono-dev] mono.data.sqlite problems - Index.RebuildIndex() is called after I call "SELECT * FROM ..."

2012-04-18 Thread gregsan
Hi guys, I'm using Mono.Data.Sqlite to load a database that I created on Windows and moved to my Ubuntu. When I run my app which loads the content of a particular table in the database, the rebuilding of index is called down the line. This rebuilding takes a lot of time (cca 10 min). AFter that, t