-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
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
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
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
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
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
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
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
8 matches
Mail list logo