Re: [sqlite] SQLITE starvation.

2013-01-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/01/13 07:59, Shuki Sasson wrote: > When we run the test we see that two threads are trying hundreds of > time to get through the begin unsuccessfully. Look at the code for the default busy handler (sqliteDefaultBusyCallback). It keeps retrying

Re: [sqlite] Is anyone have problems called sqlite3 on the WindowsPhone using VB?

2013-01-17 Thread Joe Mistachkin
drj1...@aol.com wrote: > > I am using VB and trying to call sqlite3.dll on the Windows 8 Phone > development environment , I want to find out whether that version of the DLL > supports calls from VB ? > >From VB, you'll need to use one of the available managed wrappers available for

Re: [sqlite] Multi-column index is not used with IN operator

2013-01-17 Thread Dan Kennedy
On 01/17/2013 09:17 PM, Selen Schabenberger wrote: I was trying to avoid the INDEXED BY or the "+" operator as I cannot make sure that the search with the index will always (for every database created by my application) be faster than with the PK. I prefer the optimizer does the cost

Re: [sqlite] Multi-column index is not used with IN operator

2013-01-17 Thread Selen Schabenberger
I was trying to avoid the INDEXED BY or the "+" operator as I cannot make sure that the search with the index will always (for every database created by my application) be faster than with the PK. I prefer the optimizer does the cost calculations and makes the choice.  Do you want me to write

Re: [sqlite] Multi-column index is not used with IN operator

2013-01-17 Thread Dan Kennedy
On 01/17/2013 06:32 PM, Selen Schabenberger wrote: Dan, I have just realised that with the sqlite_stat3 table, the query optimizer uses the INDEX IDX_TAG. When I drop this table, the PK is used as you said. But the concatenated index is still not used with the stat3. Looks like with stat3

[sqlite] Is anyone have problems called sqlite3 on the Windows Phone using VB?

2013-01-17 Thread DRJ1000
Hi, I am using VB and trying to call sqlite3.dll on the Windows 8 Phone development environment , I want to find out whether that version of the DLL supports calls from VB ? Thanks, Jerry ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Multi-column index is not used with IN operator

2013-01-17 Thread Selen Schabenberger
Dan, I have just realised that with the sqlite_stat3 table, the query optimizer uses the  INDEX IDX_TAG. When I drop this table, the PK is used as you said. But the concatenated index is still not used with the stat3. Knowing that the query could be 60 times faster, is there anything I can do

Re: [sqlite] Intermittent "malformed database schema"

2013-01-17 Thread Stephen Chrzanowski
Can you get rid of the SSD portion, and see if you can emulate this on another type of drive listed below and see if you get the same results? USB Key - Slowest Platter - Slower RAM Drive - Faster RAM - Fastest (RamDrive is marked as faster as there's still going to be latency converting from a