Re: [sqlite] SQLite version 3.7.0

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/21/2010 08:01 PM, Darren Duncan wrote: > Simply substituting in 3.7.0 causes a few new test failures for me with the > Perl > binding, DBD::SQLite, citing "disk I/O error". I can't speak for the Perl binding, but some of the underlying error

Re: [sqlite] SQLite version 3.7.0

D. Richard Hipp wrote: > Of course, if you do happen to run into problems, please let me know at once. > Thanks! Simply substituting in 3.7.0 causes a few new test failures for me with the Perl binding, DBD::SQLite, citing "disk I/O error". However, it is more likely that the problem is in

Re: [sqlite] Very Slow DB Access After Reboot on Windows

On 21 Jul 2010, at 4:56pm, Samet YASLAN wrote: > I have a 30MB DB file with 4 tables. > Execution time for a query is 1 sec normally but it is like 40 secs > after restarting window. > This seems to be related with file caching of Windows. The same source > code does not cause this problem on

[sqlite] sqlite website bug

Hy. I think i found a "bug" on the website. Please take a look. from the news page of the website: --- 2009-Sep-11 - Version 3.6.18 Beginning with this release, the SQLite source code is tracked and managed using the Fossil distributed

[sqlite] SQLITE_ABORT is set instead of SQLITE_SCHEMA when precompiled statement expires

Hi all, I'm using sqlite 3.6.22-1 in ubuntu 10.04. If a precompiled statement become expired, and sqlite3_step() is called, documentation says that it will fail with a SQLITE_SCHEMA error. /* Opcode: Expire P1 * * * * ** ** Cause precompiled statements to become expired.

[sqlite] Very Slow DB Access After Reboot on Windows

I have a 30MB DB file with 4 tables. Execution time for a query is 1 sec normally but it is like 40 secs after restarting window. This seems to be related with file caching of Windows. The same source code does not cause this problem on Linux. Any ideas? -- *Samet YASLAN*

[sqlite] SQLite version 3.7.0

SQLite version 3.7.0 is now available on the website http://www.sqlite.org/ The most important change in version 3.7.0 is that SQLite now supports write-ahead logs as an optional method for transaction control, for improved performance and concurrency. Additional information can be found

Re: [sqlite] UPDATEing a SELECTion in one shot

Kees Nuyt, out of the goodness of his heart, wrote: > On Wed, 21 Jul 2010 14:28:12 -0400, "jose isaias cabrera" > wrote: > >> >>Greetings and salutations. >> >>I believe this is possible, but I can not seem to get the syntax from the >>site. I have these 3 commands and 3 different steps that

Re: [sqlite] UPDATEing a SELECTion in one shot

On Wed, 21 Jul 2010 14:28:12 -0400, "jose isaias cabrera" wrote: > >Greetings and salutations. > >I believe this is possible, but I can not seem to get the syntax from the >site. I have these 3 commands and 3 different steps that I want to put into >one: > >1. result1 =

Re: [sqlite] UPDATEing a SELECTion in one shot

Pavel Ivanov willingly and out of the goodness of his heart wrote: > If the following can be considered as one step then do it like this: > > BEGIN; > UPDATE LSOpenSubProjects > SET price = (SELECT sum(price) FROM table1 WHERE subProjID = 24), >udate = now > WHERE subProjID =

Re: [sqlite] UPDATEing a SELECTion in one shot

If the following can be considered as one step then do it like this: BEGIN;      UPDATE LSOpenSubProjects SET price = (SELECT sum(price) FROM table1 WHERE subProjID = 24),       udate = now WHERE subProjID = 24;      UPDATE LSOpenProjects SET price = (SELECT sum(price) FROM

[sqlite] UPDATEing a SELECTion in one shot

Greetings and salutations. I believe this is possible, but I can not seem to get the syntax from the site. I have these 3 commands and 3 different steps that I want to put into one: 1. result1 = SELECT sum(price) FROM table1 WHERE subProjID = 24; 2. result2 = SELECT sum(price) FROM table2

Re: [sqlite] Cost of PRAGMA database_list

On 21 Jul 2010, at 2:30pm, Sam Carleton wrote: > My issue with only attaching to the EventDB for only as long as a command is > trying to use it is: The EventDB is used a LOT, a WHOLE lot. If I attach > and drop between each little call, then within one HTTP request I might > attach and drop 3

Re: [sqlite] Cost of PRAGMA database_list

On Tue, Jul 20, 2010 at 8:34 PM, Simon Slavin wrote: > > On 21 Jul 2010, at 12:42am, Sam Carleton wrote: > > > There are two equally > > important requires, one is to connect to the second "EventDB", the other > is > > that the system admin can change the EventDB at any

[sqlite] Google suggestions using FTS3

We are at the early stages of development of a full text search facility on a small (<5000 rows) database with a few text fields in an embedded application. One of our requirements is to implement Google-like suggestion prompts as the user enters the search string. A similar requirements was

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

Try to launch your appliztion with "Run As Administrator"(right click on exe -> Run As..). Note: Take care about fields information for old DB and new DB while opening tables(backward compatibility). For ex: old DB might have x number of fields and new DB might have y number fields where x is not

Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON

On Jul 21, 2010, at 11:12 AM, wrote: > > In my case, the DB is created by the older version of application and > now the new version of application is installed and End user has > option > to see old data with selecting old version of DB