On Mon, Aug 22, 2005 at 08:44:07AM +0800, Damian Slee wrote:
> >>In order to implement the ORDER BY clause, SQLite reads the entire result
> >>set into memory and sorts it there. When your result set gets very large
> >>(13000 rows) and each row uses in excess of 1KB or memory,this is
> >>appar
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm working out an assistive-type program that allows applications
developers to offer help to the user reactive to certain conditions.
This program tracks what messages are sent, reacted to, followed,
dismissed, etc. I want to store this information
>>In order to implement the ORDER BY clause, SQLite reads the entire result set
>>into memory and sorts it there. When your result set gets very large (13000
>>rows) and each row uses in excess of 1KB or memory,this is apparently causing
>>your machine to thrash.
If an index exists on the sam
Khamis Abuelkomboz wrote:
D. Richard Hipp wrote:
Version 3.2.3 of SQLite is now available on the website
http://www.sqlite.org/
In addition to fixing a lot of minor bugs, this release
adds a number of important new enhancements. Most of
the enhancements are centered around the much-improved
D. Richard Hipp wrote:
Version 3.2.3 of SQLite is now available on the website
http://www.sqlite.org/
In addition to fixing a lot of minor bugs, this release
adds a number of important new enhancements. Most of
the enhancements are centered around the much-improved
query optimizer, but there a
On Sun, 21 Aug 2005, Mark de Vries wrote:
> > > I have tried two versions of the trigger:
> > >
> > > CREATE TRIGGER task_list_1
> > > AFTER INSERT ON task_list
> > > BEGIN
> > > UPDATE task_list
> > > SET insert_ts = datetime('now','localtime'),
> > >
On Sun, 21 Aug 2005, Puneet Kishor wrote:
>
> On Aug 21, 2005, at 9:20 AM, <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > There was some recent discussion about timestamp triggers, something I
> > have been trying to get working on my own. Specifically, I have two
> > fields, insert_ts and last_upd
On Sun, 2005-08-21 at 14:26 -0400, Kervin L. Pierre wrote:
> > Note: This will only work if the "size" column
> > comes before the "data" column in the table
> > definition.
>
> Thanks for the heads up. Out of curiosity,
> why does the size column have to come before
> the data column?
>
When
Version 3.2.3 of SQLite is now available on the website
http://www.sqlite.org/
In addition to fixing a lot of minor bugs, this release
adds a number of important new enhancements. Most of
the enhancements are centered around the much-improved
query optimizer, but there are some unrelated addition
D. Richard Hipp wrote:
Are you trying to estimate the size of a table,
or a single row in that table? Your words say
the table but the context suggest you really
want the size of a row.
I need the table. But I thought if I could
have the row, calculating the total for the
table wouldn't b
On Sun, 2005-08-21 at 13:43 -0400, Kervin L. Pierre wrote:
> Hello,
>
> I am trying to figure out a way to return
> the actual or approximate table size in a
> database.
>
> Basically, in my application a table relates
> to an object and I need to calculate the
> approximate size of an object.
>
Hello,
I am trying to figure out a way to return
the actual or approximate table size in a
database.
Basically, in my application a table relates
to an object and I need to calculate the
approximate size of an object.
There is the sqlite3_column_bytes(), but I
understand that that function retu
> Both insert_ts and last_upd_ts get updated when I try this.
> What version of SQLite are you using? What platform? What
> language binding?
I'm running sqlite 3.2.2 on Win XP, and I'm running things inside
sqlite itself, not another language.
Thanks for the help!
Bill
Hello,
I'm pleased to announce the new beta of SQLite Analyzer
- New "Data Editor" allow to use "WHERE..., LIMIT.. OFFSET"
clause.
- Ability to view BLOB column as picture and as text.
- Ability to load BLOB data from file or save to file and edit BLOB
data.
You can downloa
On Sun, 2005-08-21 at 10:20 -0400, [EMAIL PROTECTED] wrote:
> There was some recent discussion about timestamp triggers, something I
> have been trying to get working on my own. Specifically, I have two
> fields, insert_ts and last_upd_ts, which I would like to be the insert
> time and last updat
On Aug 21, 2005, at 9:55 AM, <[EMAIL PROTECTED]> wrote:
can someone explain to me why folks try to accomplish the above using
TRIGGERs when the insert time can be set so easily by simply defining
the column as
insert_ts DATETIME DEFAULT CURRENT_TIMESTAMP
and last_upd_ts (or its equiva
> can someone explain to me why folks try to accomplish the above using
> TRIGGERs when the insert time can be set so easily by simply defining
> the column as
>
> insert_ts DATETIME DEFAULT CURRENT_TIMESTAMP
>
> and last_upd_ts (or its equivalent) can set in the application logic
> and u
On Aug 21, 2005, at 9:20 AM, <[EMAIL PROTECTED]> wrote:
Hi,
There was some recent discussion about timestamp triggers, something I
have been trying to get working on my own. Specifically, I have two
fields, insert_ts and last_upd_ts, which I would like to be the insert
time and last update ti
Hi,
There was some recent discussion about timestamp triggers, something I
have been trying to get working on my own. Specifically, I have two
fields, insert_ts and last_upd_ts, which I would like to be the insert
time and last update time, respectively. However, when I try to write
a trigger to
D. Richard Hipp wrote:
I am running on linux, and I will need this to scale to at least
200,000 rows
If you upgrade to the vary latest code in CVS (version 3.2.2+)
and you create an index like this:
CREATE INDEX idx ON table(parent_name, name);
Then the query above should be very
O well, read-only?
Then exclusive as well :)
- Original Message -
From: "Walter Meerschaert" <[EMAIL PROTECTED]>
To:
Sent: Sunday, August 21, 2005 2:04 AM
Subject: Re: [sqlite] Why can i open a textfile?
I agree, since that makes error/exception handling easier. On the
subject of o
21 matches
Mail list logo
