Hi,
I have a DB containing about 6 million records with my indexes
properly created. When I run a query against a particular column where
a particular (varchar) value is present, it returns very quickly.
e.g.
select * from myTable where column2='abcd';
(Returns pretty quick)
However if I use s
Dear Kervin,
> Can you run the sqlite3 under dbx? You may have better luck
> getting a backtrace that way instead of reading the core file
> after the crash. eg. 'dbx -r sqlite3' or something similar.
Thanks for the suggestion, but I already tried that with exactly the
same results.
Kind regard
In addition to what D.R. Hipp said, you are also creating and closing your
db before you get the chance to enter any data, what you really need is to
create a procedure to (1) open db (2) enter data and (3) close db every
time the "execute" button is pressed. Below is a complete working example
of
Steve,
I works very similar to ADO. Except no Data Control
Ray
Steve O'Hara <[EMAIL PROTECTED]> wrote:
How does a C++ wrapper help someone using VB6?
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of RAY BORROR
Sent: 29 July 2005 05:22
To: s
Am 01.08.2005 um 21:41 schrieb Kervin L. Pierre:
scunacc wrote:
I have built with debugging on, and can't do anything with the
core dump:
dbx Type 'help' for help.
enter object file name (default is `a.out', ^D to exit): sqlite3
reading symbolic information ...
[using memory image in core]
scunacc wrote:
I have built with debugging on, and can't do anything with the core
dump:
dbx
Type 'help' for help.
enter object file name (default is `a.out', ^D to exit): sqlite3
reading symbolic information ...
[using memory image in core]
Illegal instruction (reserved addressing fault) i
See my comments below.
On Mon, 2005-08-01 at 21:06 +0200, Peter Berkel wrote:
> Hallo,
>
> I am not an expert in programming and I try make a frontend
> for sqlite using tcl/tk. See example code below.
>
> I have the following problem. I try to entry data which I want to insert in a
> sqlite
Hallo,
I am not an expert in programming and I try make a frontend
for sqlite using tcl/tk. See example code below.
I have the following problem. I try to entry data which I want to insert in a
sqlite database. The Values of the textvariables a b and c in the entry widget
are set in the inser
Dear Jay,
> Are you running out of memory?
The machine has 6GB...
I don't think so. It's possible.
Actually, since the query will run with the 64-bit command line version
I don't *think* so.
Thanks for the thought though.
Kind regards
Derek Jones.
> ... gave me enough fodder to waste a bit more time ...
FWIW, the SQLite date/time functions were designed so that
dates could be stored as astronomical julian-day numbers
(floating point). That's the only form that gives millisec
precision, but some other form may be more convenient for
a partic
Is it me doing something wrong (again :) )?
I have a transaction and renaming a table like table1 to let's say table1_tmp
(whatever)
I open table1_tmp using prepare.
Right after that i create a table named table1, i get an error 6.
Previously i used gettable instead of prepare and left it open an
I have seen the possible format's sqlite seems to understand.
However MMDDTHH:MM:SS having the T is not prefereable to me.
This would be my favourite:
MMDD HH:MM:SS
Maybe a more recognizable fieldtype like "DATE", "DATE-TIME" or "TIME" might
help also.
It's better sqlite enforces a rule
On 7/31/05, scunacc <[EMAIL PROTECTED]> wrote:
> Dear all,
>
> SQLite is wonderful. Thank you for this piece of software.
>
> I have a problem however with large tables > 1M rows.
Are you running out of memory?
Henry Miller wrote:
On 8/1/2005 at 08:41 Puneet Kishor wrote:
I am curious about this as well... not about the various functions, but
what is, if at all, a better way to store the values -- as '-MM-DD
HH:MM:SS' strings (are they not stored internally as just strings?) or
as unixepoch tim
On 8/1/2005 at 08:41 Puneet Kishor wrote:
>I am curious about this as well... not about the various functions,
but
>what is, if at all, a better way to store the values -- as '-MM-DD
>HH:MM:SS' strings (are they not stored internally as just strings?) or
>as unixepoch time (which would li
We get a strange assertion in the sqlite3 code in our app which is
multithreaded and heavily uses sqlite.
The assertion we get is from within balance_nonroot in btree.c, line
4085:
assert( cntNew[0]>0 );
We use separate database connections from each thread (actually, more
likely, even m
On Aug 1, 2005, at 7:57 AM, Griggs, Donald wrote:
Re:
Wonder what the best way is to store a date (and time).
Hello Edwin,
If you haven't already, you'll want to read about the sqlite date/time
functions at:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
I am curious a
Re:
Wonder what the best way is to store a date (and time).
Hello Edwin,
If you haven't already, you'll want to read about the sqlite date/time
functions at:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
Donald Griggs
Opinions are not necessarily those of Misys Healthcare
Wonder what the best way is to store a date (and time).
At this time i use "mmdd" but is there a by sqlite recommended method?
This aplies time as well, not sure what i'll use, prob HH:MM:SS.
But then it lacks ms's.
I wrote a byte to hex converter which is very fast.
I'm very pleased with the poss. of using the X'' notation.
Saves all kinds of (future?) problems.
- Original Message -
From: "Cory Nelson" <[EMAIL PROTECTED]>
To:
Sent: Sunday, July 31, 2005 7:58 PM
Subject: Re: [sqlite] quoting
s
20 matches
Mail list logo
