Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

Ed Tenholder wrote: > > (5) There are at most three SqlDataSource controls on any page, and it is > possible that each would have the same data connection open simultaneously, > but all for read access, except when inserting or deleting a record. The > performance problem occurs when only

[sqlite] sqlite error

Hi all, sqlite throws error code 1 while sqlite busy with read/write operations. what could be the reason. But, I could not reproduce this with test program. what is the best way to handle sqlite error. Is it like sqlite abort case? Thanks, d b ___

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

Thanks for the quick reply. (1) The queries are specified in the SqlDataSource. Examples: "SELECT * FROM [Scores] WHERE ([Player] = @Player) ORDER BY [ScoreDate] DESC" No more than a few hundred rows in the table. (2) I will look into the LogPrep and TraceListener and see what I can do

Re: [sqlite] Solving the Sudoku with SQlite 3.8.3 trunk

On Sat, Jan 18, 2014 at 3:38 PM, big stone wrote: And : > - python3.4 is still in beta also, not a released product. > - sadly first RC candidate 1 is February 9, 2014, 2 days earlier. > > Sqlite was so close now, *so close* to achieve this goal ... > Maybe you could

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

Ed Tenholder wrote: > > The asp.net app is several pages, each with from one to three datagrids that > are filled using ADO.NET. Very little actual code. Using GridView, > DetailsView, DropDownList, and SqlDataSource > (ProviderName="System.Data.SQLite") controls. > Do you know what kind of

[sqlite] Significant Performance Problem with System.Data.SQLite.

I've finally finished converting from SQLserver Express to SQLite for an ASP.NET app on my development machine. VS 2010 Professional. System.Data.SQLite version 1.0.90.0, and 1.0.89.0 Got everything working great in development, but did I ever have problems deploying to Win Server 2012.

Re: [sqlite] Bug: 3.8.2 assertion failure in allocateIndexInfo where 3.7.13 does not

Trouble ticket here: www.sqlite.org/src/tktview/1a1a194d1e5f8 On Mon, Jan 20, 2014 at 1:38 PM, Mary Holstege wrote: > > The setup here is a virtual table with two columns > and a query of the form: > > select c1,c2 from test where c1 > The code in exprAnalyze

[sqlite] Bug: 3.8.2 assertion failure in allocateIndexInfo where 3.7.13 does not

The setup here is a virtual table with two columns and a query of the form: select c1,c2 from test where c1op==TK_COLUMN ){ pTerm->leftCursor = pLeft->iTable; pTerm->u.leftColumn = pLeft->iColumn;

Re: [sqlite] SQLITE 3.8.3 beta: SQLITE_OMIT_CTE build doesn't work

2014/1/20 Richard Hipp : > That single-macro fix allows it to compile and run. But there are memory > leaks associated with that fix that would need to be plugged before we > could use it in a release. Well, I didn't think about memory leaks Never mind. Since CTE doesn't

Re: [sqlite] SQLITE 3.8.3 beta: SQLITE_OMIT_CTE build doesn't work

On Mon, Jan 20, 2014 at 9:23 AM, Jan Nijtmans wrote: > 2014/1/20 Dan Kennedy : > > Looks like SQLITE_OMIT_CTE only works with full source builds, not > > the amalgamation. As it causes code to be omitted from parse.y. > > > > There are a few others

[sqlite] InsertOnSubmit with LinqToSQL

Hi, i'm testing a little code to test sqlite in C# with FrameWork 3.5 SP1 and earlier Ssytem.Data.Sqlite library. My code works fine to insert an entity with a specific ID, but i'm not able to do it with the autoIncrement... Someone knows what is wrong in my code ? Tnanks * My class table :

Re: [sqlite] SQLITE 3.8.3 beta: SQLITE_OMIT_CTE build doesn't work

2014/1/20 Dan Kennedy : > Looks like SQLITE_OMIT_CTE only works with full source builds, not > the amalgamation. As it causes code to be omitted from parse.y. > > There are a few others this is true of as well - OMIT_VIRTUALTABLE, > OMIT_TRIGGER etc. Sure, but since

Re: [sqlite] SQLITE 3.8.3 beta: SQLITE_OMIT_CTE build doesn't work

On 01/20/2014 08:36 PM, Jan Nijtmans wrote: $ gcc -c -Wall -o sqlite3.o -DSQLITE_OMIT_CTE sqlite3.c sqlite3.c: In function ‘yy_reduce’: sqlite3.c:117782:3: warning: implicit declaration of function ‘sqlite3WithAdd’ [-Wimplicit-function-declaration] yygotominor.yy59 = sqlite3WithAdd(pParse,

[sqlite] SQLITE 3.8.3 beta: SQLITE_OMIT_CTE build doesn't work

$ gcc -c -Wall -o sqlite3.o -DSQLITE_OMIT_CTE sqlite3.c sqlite3.c: In function ‘yy_reduce’: sqlite3.c:117782:3: warning: implicit declaration of function ‘sqlite3WithAdd’ [-Wimplicit-function-declaration] yygotominor.yy59 = sqlite3WithAdd(pParse, 0, [-5].minor.yy0, yymsp[-4].minor.yy14,

Re: [sqlite] Dramatic performance difference between different "PRAGMA synchronous" settings for bulk inserts

> Unrelated to your question, but, take a look at "external content" FTS4 table > they dramatically cut down the amount of duplicated data [1]) Thanks for the tip. I'll definitely check that. Currently I build the contents for FTS from several other tables, combining, splitting, merging data via

[sqlite] Minor documentation typos in PRAGMA command syntax section?

(0) After the second syntax diagram there is this sentence: "The argument is may be either in….." ^^^ which should read "The argument may be either …." (1) In the next paragraph there is the following: "Some pragmas takes a string literal as their argument.."

Re: [sqlite] Sqlie from c#: encoding bug?

Sounds like you're passing a non utf-8 encoded string from C# directly to sqlite. The easiest way I know of to check the actual data in the database is to dump it as hex (i.e., select hex(column_name)) and check if the contents are what you expect or not. Gut feeling is that the strings in

Re: [sqlite] Dramatic performance difference between different "PRAGMA synchronous" settings for bulk inserts

On Sun, Jan 19, 2014 at 10:59 PM, Mario M. Westphal wrote: > If I set wal_autocheckpoint=1, I will get 1/10 of the synchs and WAL > file of about 10 MB, correct? http://www.sqlite.org/pragma.html#pragma_wal_autocheckpoint states it's a page count, so that depends on