[sqlite] Redundant link in documentation

Hi, In the following page: http://sqlite.org/c3ref/bind_parameter_index.html there is a link to itself: sqlite3_bind_parameter_index(). Maybe it should have been a link to: http://sqlite.org/c3ref/bind_parameter_name.html ? Regards.

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

On 4 Aug 2015, at 6:35pm, Scott Hess wrote: > BUT, keep in mind that you might find that you've just moved the 1min time > from query time to preload time, in which case you've just complexified > without adding anything. That's why I didn't give any advice. /Something/ has to load those secto

[sqlite] Compile Warning from Universal Windows App using Visual Studio 2015

Please update to the version updated on 2015-07-31 and try again. Sent from my iPhone > On Aug 4, 2015, at 7:19 PM, Weidong Shen wrote: > > Hi, > > I created a test UWP project using Visual Studio 2015/Windows 10 and added a > reference to "SQLite.UAP.2015, Version=3.8.11.1". When compiling

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

On 3 Aug 2015, at 1:58pm, Linquan Bai wrote: > I am trying to read large data from the database about 1 million records. > It takes around 1min for the first time read. But if I do the same process > thereafter, the time is significantly reduced to 3 seconds. How can I get a > fast speed for the

[sqlite] SQLite EF provider

Hi Michel. A fully featured EF provider is available from DevArt. https://www.devart.com/dotconnect/sqlite/ /Erik Sendt fra Windows Mail

[sqlite] Numerics bigger than 32-bit and sqlite as 64-bit TCL extension

2015-07-28 11:52 GMT-05:00 Richard Hipp : > On 7/28/15, Rafa? Ponikwia wrote: >> Hi, >> I'm using sqlite3 TCL extension from Teapot (version 64-bit). When I try >> to insert number bigger than signed 32-bit it inserts wrong number to >> database. >> % sqlite3 db C:/tmp/test.sqlite >> % db eval {

[sqlite] Numerics bigger than 32-bit and sqlite as 64-bit TCL extension

On Tue, Aug 4, 2015 at 12:34 PM, Jan Nijtmans wrote: > 2015-07-28 11:52 GMT-05:00 Richard Hipp : >> On 7/28/15, Rafa? Ponikwia wrote: >>> Hi, >>> I'm using sqlite3 TCL extension from Teapot (version 64-bit). When I try >>> to insert number bigger than signed 32-bit it inserts wrong number to >>>

[sqlite] SQLite Entity Framework Provider

Michel Feinstein wrote: > > So, I ask (or beg) that the community make a new provider that can be used > with Entity Framework 6.1.3 Code First, support migrations and the Sync > Framework. > Is there is a list somewhere of what's missing from the System.Data.SQLite.EF6 provider that would enabl

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

On Tue, Aug 4, 2015 at 10:45 AM, Simon Slavin wrote: > > On 3 Aug 2015, at 1:58pm, Linquan Bai wrote: > > > I am trying to read large data from the database about 1 million records. > > It takes around 1min for the first time read. But if I do the same > process > > thereafter, the time is signi

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

On Tue, Aug 4, 2015 at 9:23 AM, John McKown wrote: > On Tue, Aug 4, 2015 at 10:45 AM, Simon Slavin > wrote: > > On 3 Aug 2015, at 1:58pm, Linquan Bai wrote: > > > I am trying to read large data from the database about 1 million > records. > > > It takes around 1min for the first time read. But

[sqlite] SQLite Entity Framework Provider

EF6 provider implementation in System.Data.SQLite.EF6 doesn't create tables so it can't work using EF Code First. Apparently EF7 will support this in a new, Microsoft made sqlite provider, but this will take still a long time to appear and EF7 might not be as complete as EF6 http://www.wintellect.