Roger Binns wrote:
> 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
> handling (invalid
-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
h
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/21/2010 12:22 PM, Aleksander Morgado wrote:
> Now, apart from the issue above, is there any other method to know if a
> precompiled statement expired? I see that sqlite3_expired() is marked as
> deprecated, so what would be the equivalent?
The t
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 DB
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 L
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 configuration
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.
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 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
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 I
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 = SELECT sum(price) FROM
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 = 24;
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 ta
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 WHE
On Wed, Jul 21, 2010 at 11:23 AM, Simon Slavin wrote:
>
> On 21 Jul 2010, at 3:53pm, Sam Carleton wrote:
>
> > In the end, I am looking for the best way to determine if the connection
> > contains the correct EventDB, since a connection can live for a LONG LONG
> > time.
>
> Sorry, I misunderstoo
On 21 Jul 2010, at 3:53pm, Sam Carleton wrote:
> In the end, I am looking for the best way to determine if the connection
> contains the correct EventDB, since a connection can live for a LONG LONG
> time.
Sorry, I misunderstood. I thought that your process lasted only long enough to
answer on
On Wed, Jul 21, 2010 at 9:47 AM, Simon Slavin wrote:
>
> 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 l
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
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 time.
>
> You mean change
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 d
20 matches
Mail list logo