Re: [sqlite] Bad UPDATE performance

On May 14, 2009, at 4:08 AM, Ofir Neuman wrote: > Thanks Dan this was very helpful it seems that I have a similar > problem. > > Didn't try the patch yet but I find out a scenario to reproduce the > problem. > > 1. Process A perform UPDATE on bunch of records (within transaction) > 2.

[sqlite] How to do ranking/scoring in FTS3

Hi all. I have a problem on how to do a ranking on FTS3 because by only using the SQLite CREATE VIRTUAL TABLE function, there is no ranking or scoring applied to result. So my question is, how to implement a scoring system on FTS3 so that, the result is shown with the highest score first? I

Re: [sqlite] Full Text Search

Hi, Newbie on SQLite here. I also have the same problem on how to do a ranking on FTS3 but no clue. And I found that you use a function call score() that do sorting. But it is not found in SQLite doc. So, can you please tell me how can I get this function or, can you please tell me what is

Re: [sqlite] how do I use more than one column as a "combined key"?

I don't undertand what is your question? a) You know to do it in SQL but you don't in SQLite or b) You dont know how to do it in any SQL yaconsult escribió: > SQL newbie here. Sqlite has been a fantastic tool for analyzing, comparing > and correcting lots of account information. But I've hit a

Re: [sqlite] problem with sqlite in c#.net

do you try a COMMIT? manp escribió: > when i execute a query like this > UPDATE setting SET value="red" WHERE name="color" > the row will update temporary while app is running , when i close app noting > appear in DB > i use ManagedSQLite dll ___

Re: [sqlite] Blob length in characters vs size in bytes

On 14/05/2009 12:23 AM, Salvatore Di Guida wrote: > Hi all! > Since I am a newcomer in SQLite, as a preliminary question, what is the > difference between > sqlite> select length(X'01'); > and > sqlite> select length('01'); > It seems that the former gives the size in bytes, the latter the

Re: [sqlite] Bad UPDATE performance

Thanks Dan this was very helpful it seems that I have a similar problem. Didn't try the patch yet but I find out a scenario to reproduce the problem. 1. Process A perform UPDATE on bunch of records (within transaction) 2. Afterward, process B perform the same UPDATE operation but only on a

Re: [sqlite] Bad UPDATE performance

Thanks for the answer Pavel, I'm using synchronous = FULL as the data in my application is the most important part. Changed the journal_mode to PERSIST same result the journal file is 3 times bigger than what it should be and the results are bad. Thanks, Ofir. ---Original

Re: [sqlite] Blob length in characters vs size in bytes

Salvatore Di Guida wrote: > If so, why do this query return very different answers: > sqlite> select length(X'01'); > 1 > sqlite> select length(X'0'); > SQL error: unrecognized token: "X'0'" ? X'0' is not a valid BLOB literal, so SQLite reports a syntax error. BLOB

Re: [sqlite] Blob length in characters vs size in bytes

Hi! Other questions inline: > To: sqlite-users@sqlite.org > From: itandet...@mvps.org > Date: Wed, 13 May 2009 11:48:11 -0400 > Subject: Re: [sqlite] Blob length in characters vs size in bytes > > Salvatore Di Guida > wrote: > > Since I am a newcomer in SQLite, as a

Re: [sqlite] Blob length in characters vs size in bytes

Salvatore Di Guida wrote: > Since I am a newcomer in SQLite, as a preliminary question, what is > the difference between > sqlite> select length(X'01'); > and > sqlite> select length('01'); > It seems that the former gives the size in bytes, the latter the > length of the

[sqlite] SQLite export plugin for MySQL Workbench

Hi everyone, I'd like to announce the release of my SQLite export plugin for MySQL Workbench. The plugin is available under GPL, just like the Community Edition (OSS) of Workbench for which it was developed. With this plugin, one can combine the visual database design capabilities of MySQL

[sqlite] Blob length in characters vs size in bytes

Hi all! Since I am a newcomer in SQLite, as a preliminary question, what is the difference between sqlite> select length(X'01'); and sqlite> select length('01'); It seems that the former gives the size in bytes, the latter the length of the string. The SQLite documentation says that the

Re: [sqlite] help,low RAM problem

In my app, I had to adjust the default cache size. This was 2000 pages and caused my app to run out of memory. I dropped it down to 200. You may want to drop it even further. Chris ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] database is locked and is malformed

On May 13, 2009, at 4:09 AM, s.breith...@staubli.com wrote: > We use QNX 6.3 on a ppc with sqlite as database for our application. > As > there was a speed problem in older sqlite versions we used the PRAGMA > SYNCHRONOUS = OFF command before creating an INSERT and the PRAGMA > SYNCHRONOUS =

[sqlite] Accessing tables containing multiple Blobs

Assume you have a table mytable(id, blob1, blob2,blob3). You have a page_size of 1k and each blob is in average 20KBytes, i.e. a row is of size 60KByte. My question now is where does the projection of an sql-statement like "select blob2 from mytable where id=777" take place. Are all 60KBytes

[sqlite] database is locked and is malformed

We use QNX 6.3 on a ppc with sqlite as database for our application. As there was a speed problem in older sqlite versions we used the PRAGMA SYNCHRONOUS = OFF command before creating an INSERT and the PRAGMA SYNCHRONOUS = ON afterwards. We used version 3.4.2 for a long time, 2 month ago we