Re: [sqlite] Views and performances...

2004-08-12 Thread Andrew Piskorski
On Thu, Aug 12, 2004 at 03:38:21PM +0100, Christian Smith wrote: > AFAIK, views are compiled into their query definitions when executing a > statement, so once the compilation is done, performance should be > identical to their raw query form. > In short, create a view if you have a common

Re: [sqlite] Deadlock when doing threaded updates and inserts

2004-08-12 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: I'll look into adding a PRAGMA that makes BEGIN TRANSACTION acquire a RESERVED lock immediately. That will reduce the amount of confusion about this issue, I suppose. Does enabling this PRAGMA regenerate the reader starvation problem of 2.8.x, or is that problem solved

Re: [sqlite] Deadlock when doing threaded updates and inserts

2004-08-12 Thread D. Richard Hipp
Tito Ciuro wrote: I'm definitely not happy about this... Let me get this right... it seems that you're cruising along fine with SQLITE_OK's all over the place when suddenly one of your threads/processes get a SQLITE_BUSY signal in the middle of a transaction. In order to solve the crisis, one

[sqlite] Sqlite on Zaurus

2004-08-12 Thread Jean Bort
Hello, First, sorry for my english. I use Sqlite for Zaurus Application and for this, I generate a sqlite ipk. It can be download here : http://penbase.net/~jean/sqlite_2.8.15_arm.ipk I write a french documentation for compile and package Sqlite for Zaurus. Bye Jean

[sqlite] sqlite3_busy_timeout ignored while doing multi-threaded updates ?

2004-08-12 Thread George Ionescu
Hello SQLite users, Hello Dr. Hipp, while doing updates from multiple threads, I'm only able to perform an update on one thread, all the other threads returning SQLITE_BUSY. This is ok: I've read the docs and it behaves as it should. However, what I don't understand is the behavior of sqlite

Re: [sqlite] Compiling sqlite3.0.3 on dec-osf1 with gcc 3.04 failed

2004-08-12 Thread Detlef Groth
Hello, I compiled the new 3.0.4 sources without any changes on OSF-1 now. No need for the '-DUINTPTR_TYPE=unsigned long long' flag at all. However I am wondering that the shared lib for tcl is build only by invoking `make test' and that this shared lib is much smaller than the shared lib gotten