[sqlite] Re: sqite2.8 performance snag when filesize growsmore than 70MB on a 256MB ram

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 >

RE: [sqlite] Re: sqite2.8 performance snag when filesize growsmore than 70MB on a 256MB ram

>>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

Re: [sqlite] Version 3.2.3

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

Re: [sqlite] Version 3.2.3

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

Re: [sqlite] Can a trigger update more than one column?

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'), > > >

Re: [sqlite] Can a trigger update more than one column?

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

[sqlite] Version 3.2.3

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

Re: [sqlite] table or record size without reading the entire table/record?

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

Re: [sqlite] table or record size without reading the entire table/record?

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. >

[sqlite] table or record size without reading the entire table/record?

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

Re: [sqlite] Can a trigger update more than one column?

> 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

[sqlite] ANN: New version of SQLite Analyzer

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

Re: [sqlite] Can a trigger update more than one column?

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

Re: [sqlite] Can a trigger update more than one column?

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

Re: [sqlite] Can a trigger update more than one column?

> 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

Re: [sqlite] Can a trigger update more than one column?

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

[sqlite] Can a trigger update more than one column?

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

Re: [sqlite] Re: sqite2.8 performance snag when filesize grows more than 70MB on a 256MB ram

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

Re: [sqlite] Why can i open a textfile?

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