[sqlite] Fw: new message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Fw: new message

Hello! New message, please read ronny.dierckx at telenet.be

[sqlite] Problem with locked database

On 2015-11-03 06:31 PM, ALBERT Aur?lien wrote: > Hi, > > I'm often getting the "Database is locked" error message and I don't really > understand what can lead to this. > > I'm using these settings : >- sqlite3_config(SQLITE_CONFIG_MULTITHREAD) >- multiple threads >- only one sqlite

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

Jim Morris wrote: > > Is there a graceful work around? > > > (3850) SQLITE_IOERR_LOCK > Are any of the underlying database files read-only? -- Joe Mistachkin

[sqlite] MultiThread Error 10 on Windows Mobile 6.x

I have a connection used by the main (UI) thread and recently added a background thread, with own connection(no shared cache) to upload changes to server on Windows Mobile 6.0/6.5 devices and upgraded to SQLite 3.9.2. The background thread is getting an error 10, extended error 3850 as a

[sqlite] Problem with locked database

Hi, I'm often getting the "Database is locked" error message and I don't really understand what can lead to this. I'm using these settings : - sqlite3_config(SQLITE_CONFIG_MULTITHREAD) - multiple threads - only one sqlite connection per thread - each thread have a different connection

[sqlite] Problem with locked database

On 3 Nov 2015, at 4:31pm, ALBERT Aur?lien wrote: > I'm using these settings : > - sqlite3_config(SQLITE_CONFIG_MULTITHREAD) > - multiple threads > - only one sqlite connection per thread > - each thread have a different connection instance You must set a timeout for each connection you

[sqlite] how to empty a table with sqliteEstudio-2.0.26

On 2015-11-03 05:36 AM, Simon Slavin wrote: > On 3 Nov 2015, at 3:23am, H?ctor Fiandor wrote: > >> I have obtained the sqliteEstudio-2.0.26 and I need to empty a table. Is >> possible with this program? If not, how to do? > I have no idea how that program works. It is not SQLite, it is a

[sqlite] Why SQLite take lower performanceinmulti-threadSELECTing?

Adding to my own comment, the mechanical properties of the disc. If you're reading from a solid state device this does not apply, however with magnetic spinning discs there's a read head that has to move around and if you're reading from four different locations in the same file and the files

[sqlite] Why SQLite take lower performanceinmulti-threadSELECTing?

To add to what other people are saying here, it is very likely in the additional threads result in reduced overall performance because rather than having one thread have the areas of disk cache where it's reading, you know have multiple threads each at their own locations in the file such that

[sqlite] how to empty a table with sqliteEstudio-2.0.26

On 3 Nov 2015, at 3:23am, H?ctor Fiandor wrote: > I have obtained the sqliteEstudio-2.0.26 and I need to empty a table. Is > possible with this program? If not, how to do? I have no idea how that program works. It is not SQLite, it is a program which uses SQLite. If you can issue commands