Re: [sqlite] UPDATE 11 times slower than SELECT?

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

Re: [sqlite] SELECT * from ?

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,

Re: [sqlite] SELECT * from ?

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,

Re: [sqlite] SELECT * from ?

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.

[sqlite] SELECT * from ?

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

Re: [sqlite] SQLJet - pure Java implementation of SQLite

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

Re: [sqlite] SQLJet - pure Java implementation of SQLite andNestedVM version

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:

Re: [sqlite] SQLJet - pure Java implementation of SQLite and NestedVM version

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

Re: [sqlite] SQLJet - pure Java implementation 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 >

[sqlite] Sqlite logic error on commit

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

Re: [sqlite] SQLJet - pure Java implementation of SQLite

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

Re: [sqlite] SQLJet - pure Java implementation of SQLite

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

Re: [sqlite] SQLJet - pure Java implementation of SQLite

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,

Re: [sqlite] Problems with max(datestamp) in subquery

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,

Re: [sqlite] SQLJet - pure Java implementation of SQLite

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,

Re: [sqlite] Problems with max(datestamp) in subquery

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*

Re: [sqlite] Storing large numbers

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

Re: [sqlite] Storing large numbers

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

Re: [sqlite] SQL error: database disk image is malformed - other possibility than dump/load

> 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

[sqlite] Storing large numbers

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