Roger Binns writes:
> Nikolaus Rath wrote:
>> Is it normal that UPDATE still takes more than 11 times as much time as
>> SELECT, or should I be able to get better performance?
>
> The UPDATE time also includes the time waiting to acquire file locks. If
> you have concurrent activity it could take
On Thu, 2009-08-13 at 01:12 +0100, Simon Slavin wrote:
> On 12 Aug 2009, at 11:35pm, Igor Tandetnik wrote:
>
> > Bill Welbourn
> > wrote:
> >> I am new to the forum and have a question regarding querying data
> >> from a table, where the table name is random. For example, I have a
> >> database p
On 12 Aug 2009, at 11:35pm, Igor Tandetnik wrote:
> Bill Welbourn
> wrote:
>> I am new to the forum and have a question regarding querying data
>> from a table, where the table name is random. For example, I have a
>> database possessing upwards of 41 tables named, TAB10, TAB11,...,
>> TAB50, an
Bill Welbourn
wrote:
> I am new to the forum and have a question regarding querying data
> from a table, where the table name is random. For example, I have a
> database possessing upwards of 41 tables named, TAB10, TAB11,...,
> TAB50, and would like to query each table.
Consider instead having a
Hi,
I am new to the forum and have a question regarding querying data from a table,
where the table name is random. For example, I have a database possessing
upwards of 41 tables named, TAB10, TAB11,..., TAB50, and would like to query
each table.
Question: Within the C programming environ
Hello Roger,
> As a matter of interest what problem exactly do you have with NestedVM?
> It's output is indeed opaque (not human comprehensible) but the same
is true
> of Java source versus bytecode. In both cases the input source is
readable.
When I first tried to use NestedVM for our needs (lo
Or else, what's throwing me off is this, in
http://www.zentus.com/sqlitejdbc/
"Both the pure driver and the native binaries for Windows, Mac OS X, and
Linux x86 have been combined into a single jar file." [...] "Pure Java
driver, always works, slowly."
g
-Original Message-
From: sqlite-u
I had the impression that the NestedVM version worked under Linux only,
is this incorrect?
g
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns
Sent: Wednesday, August 12, 2009 3:54 PM
To: General Discussion of SQLite
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Fred Williams wrote:
> I seem to remember, haven't done it in years, Borand's C and C++ compilers
> could output Assembler source. One could conceivably take that output and
> translate it into almost any foreign CPU's native Assembler with great
> ef
We are currently developing an application using Sqlite 3.6.4. The
application is written in Delphi.
In the past week or so, we have started encountering a sporadic error
result from sqlite3_error(db) of
Error code: 1
Error message: SQL logic error or missing database
when invoking a query co
Actually that makes a lot of sense. At the machine code level most of the
programmer "style" is winnowed out. Even translating to Assembler code
would be "better" than going from one high level language to another.
The translator I wrote was from Databus/Datashare (Children there use to be
a net
On 12 Aug 2009, at 4:25pm, Jim Showalter wrote:
> Perhaps it would be better to translate the object code.
>
> It's also possible to translate bytecode (for example, from Java to
> .NET).
Well since we're talking about SQLite here, another opportunity
presents itself, because SQLite3 has its o
Perhaps it would be better to translate the object code.
It's also possible to translate bytecode (for example, from Java to
.NET).
- Original Message -
From: "Fred Williams"
To: "General Discussion of SQLite Database"
Sent: Wednesday, August 12, 2009 5:42 AM
Subject: Re: [sqlite] SQL
On Wed, 2009-08-12 at 07:02 -0700, Leo Freitag wrote:
>
> I modified the code a get the following results. Unfortunetly only a little
> more as expected:
>
> DROP TABLE 'tblZO_Haupt';
> CREATE TABLE 'tblZO_Haupt' ('id' INTEGER PRIMARY KEY, 'zo_tblEnsemble'
> INTEGER, 'zo_tblSaenger' INTEGER, 'zo
Wes Freeman wrote:
>
> You were using the outside table alias in the subquery:
>
> (...)
>
> might work a little more as expected.
>
>
I modified the code a get the following results. Unfortunetly only a little
more as expected:
DROP TABLE 'tblZO_Haupt';
CREATE TABLE 'tblZO_Haupt' ('id' I
That's the problem any more it seems. Everyone "assumes" unlimited CPU and
memory :-)
Give a guy a Cray and he'll write one hell of a "Solitaire"!
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Roger Binns
Sent: Wednesday, Au
You were using the outside table alias in the subquery:
SELECT * FROM tblZO_Haupt AS hpt
WHERE hpt.datum = (
SELECT MAX(hpt_sub.datum)
FROM tblZO_Haupt AS hpt_sub
WHERE hpt_sub.zo_tblSaenger = hpt.zo_tblSaenger
AND hpt_SUB.zo_tblEnsemble = 1
AND hpt_SUB.zo_tblStueck = 1
AND h
P Kishor-3 wrote:
>
> On Mon, Aug 10, 2009 at 2:25 PM, Leo Freitag
> wrote:
>
> sqlite> SELECT * FROM haupt WHERE datestamp = (SELECT Max(datestamp)
> FROM haupt WHERE "group" = 1 AND song = 1);
> 3|1|2|1|11|2009-08-04
> sqlite>
>
> Although, I would *seriously* advise you to reconsider naming
On 11 Aug 2009, at 10:02pm, Tishchenko, Seva wrote:
> Even if I declare this column as TEXT,
> SQLite still tries to guess the value type and the output result is
> "1.23456789012346E19" as well unless I put it in quotes or add a
> non-numeric character.
Well yes, but adding quotes (single quote
On 12 Aug 2009, at 6:09am, Roger Binns wrote:
> If you read Bernstein's retrospective on qmail, one of his
> suggestions is to
> write code in a higher level language (especially more secure in the
> sense
> that C isn't such as preventing buffer & integer overflows etc) that
> is then
> tr
On Aug 11, 2009, at 5:02 PM, Tishchenko, Seva wrote:
> Hi,
>
> I'm trying to store a larges number in a SQLite column, something
> like
> "12345678901234567890". This number does not exceed 8 bytes capacity,
SQLite uses twos complement integers. The largest 8-byte twos
complement integer
>
> Is there a way to store a large number without
> loosing it's precision?
>
Are you using sqlite3_bind_int64 to bind the parameter to the statement?
Ben
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/list
> So if the corruption problem is
> confined to an index or indexes, an export/import will fix
> problem but a vacuum will not.
> Dan.
I ran into exactly that problem with Sqlite database used by Trac
(http://trac.edgewall.org/).
The solution Dan proposed here worked fine for me. That's what I d
Hi,
I'm trying to store a larges number in a SQLite column, something like
"12345678901234567890". This number does not exceed 8 bytes capacity,
however it gets truncated by SQLite to the form of
"1.23456789012346E19". Note that the number has lost 5 digits in
precision and got rounded. Even if
24 matches
Mail list logo
