Thanks to Drake Wilson and Simon Slavin. The trick was to create a VIEW
that the application uses and which has INSTEAD OF triggers to do the
right thing. This breaks the recursive triggering because there are no
recursive triggers left on the underlying table. Worked like a charm.
Nico
--
___
In oracle you can do this
Alter index storage (buffer_pool keep);
This would keep the index in memory thus allowing it to be read quicker.
Is there any way to do this in sqlite without the table or database being in
memory.
If there is not does anyone have any ideas on functions i can manipula
On 01/08/2011 08:12 AM, Nicolas Williams wrote:
> I need to use recursive triggers. In some cases I want to "normalize"
> values of some columns of NEW being INSERTed or UPDATEd, but there's no
> UPDATE syntax for changing NEW, thus I can't write something like:
>
> CREATE TRIGGER ...
> BEGIN
>
On Sat, Jan 08, 2011 at 01:29:23AM +, Simon Slavin wrote:
> On 8 Jan 2011, at 1:12am, Nicolas Williams wrote:
> > I need to use recursive triggers. In some cases I want to "normalize"
> > values of some columns of NEW being INSERTed or UPDATEd, but there's no
> > UPDATE syntax for changing NEW
On Fri, Jan 07, 2011 at 06:29:05PM -0700, Drake Wilson wrote:
> Quoth Nicolas Williams , on 2011-01-07 19:12:13
> -0600:
> > But the real problem is that my triggers will just recurse infinitely,
> > since I need both, AFTER INSERT and AFTER UPDATE triggers. The AFTER
> > INSERT trigger will trig
On 8 Jan 2011, at 1:12am, Nicolas Williams wrote:
> I need to use recursive triggers. In some cases I want to "normalize"
> values of some columns of NEW being INSERTed or UPDATEd, but there's no
> UPDATE syntax for changing NEW, thus I can't write something like:
CREATE TRIGGER fred INSTEAD O
Quoth Nicolas Williams , on 2011-01-07 19:12:13
-0600:
> But the real problem is that my triggers will just recurse infinitely,
> since I need both, AFTER INSERT and AFTER UPDATE triggers. The AFTER
> INSERT trigger will trigger the AFTER UPDATE trigger, and that one will
> trigger itself, recurs
I need to use recursive triggers. In some cases I want to "normalize"
values of some columns of NEW being INSERTed or UPDATEd, but there's no
UPDATE syntax for changing NEW, thus I can't write something like:
CREATE TRIGGER ...
BEGIN
UPDATE SET NEW.somecol = ();
END;
I must write:
CREATE TR
Alok Singh wrote on 1/7/2011 :
> Hi Guys ,
>
> I again stuck with this. kindly give your suggestion.
> Its taking time for to insert 65k of docs around 20 min.
> kindly have a look and help me on my basic code.hope this will help you all
> over my problem.
> i think something going to have huge me
On 1/7/2011 5:07 PM, Scott A Mintz wrote:
> I will need to filter on it. The six word field is called a RxIOI. So I
> will need to select records where the RxIOI equals a specified value.
>
> Is this valid if RxIOI is a blob?: select xyz from t where RxIOI =
> x'1234567890ab';
Yes, this works.
-
On 7 Jan 2011, at 9:55pm, Alok Singh wrote:
> i think something going to have huge memory or becoming lengthy here, so
> after going
> 1 in few sec
> next 10001 to 2 in 1min
> next 20001 to 3 in more than 1.5 min
> next 30001 to 4 in more than 3 min
> next 40001 to 5 in more t
I will need to filter on it. The six word field is called a RxIOI. So I
will need to select records where the RxIOI equals a specified value.
Is this valid if RxIOI is a blob?: select xyz from t where RxIOI =
x'1234567890ab';
-Scott
sqlite-users-boun...@sqlite.org wrote on 01/07/2011 04:32:1
On 1/7/2011 4:45 PM, Venkat Victorious wrote:
> On Fri, Jan 7, 2011 at 5:43 AM, BareFeetWare
> wrote:
>> This is sometimes called "re-injection", where you're extracting the
>> results of one query, only to re-inject it into another query. In SQL, this
>> is a very inefficient way to do it. Most
Hi Guys ,
I again stuck with this. kindly give your suggestion.
Its taking time for to insert 65k of docs around 20 min.
kindly have a look and help me on my basic code.hope this will help you all
over my problem.
i think something going to have huge memory or becoming lengthy here, so
after goin
Hi Tom,
Please refer inline.
Thanks
VENKATESWARAN
Bug the Bugs
On Fri, Jan 7, 2011 at 5:43 AM, BareFeetWare
wrote:
> On 06/01/2011, at 7:09 PM, stunner Easwar wrote:
>
> > I need to use local variables similar to sql syntax using DECLARE. My
> project involves lot of places where I need to se
On 1/7/2011 4:06 PM, Scott A Mintz wrote:
> I have a fixed length value of six UINT16's. Is a blob the best way to
> store it?
Depends on what you want to do with it. For example, do you need to
filter on it in queries, e.g. "find all records where the second of
those six integers is greater th
I have a fixed length value of six UINT16's. Is a blob the best way to
store it?
-Scott
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Isn't it also depending if there are columns which have the same name or not?
> On 1/7/2011 1:31 PM, Peter wrote:
>> In the C interface documentation we are told:
>>
>> "The name of a result column is the value of the "AS" clause for that
>> column, if there is an AS clause. If there is no AS clau
On 1/7/2011 1:31 PM, Peter wrote:
> In the C interface documentation we are told:
>
> "The name of a result column is the value of the "AS" clause for that
> column, if there is an AS clause. If there is no AS clause then the name
> of the column is unspecified and may change from one release of SQ
In the C interface documentation we are told:
"The name of a result column is the value of the "AS" clause for that
column, if there is an AS clause. If there is no AS clause then the name
of the column is unspecified and may change from one release of SQLite
to the next."
What exactly is mean
I have noticed a lot of discussion of comparing floating point numbers. I use
a
set of comparison functions that I have written based on the following
article.
This is a definitive guide to IEEE floating point numbers and comparisons of
such. With this information you can be very specific a
On 01/07/2011 09:19 PM, BareFeetWare wrote:
> Hi All,
>
> I have developed some software that allows the user to change the schema of
> tables. It does this by:
>
> 1. Backs up the rows from the old table into a temporary duplicate table
> 2. Drops the old table
> 3. Creates the new table
> 4. Ins
On 01/07/2011 08:49 PM, Sam Carleton wrote:
> Simon,
>
>> From what I gathered on the web site, WAL is a state of how the engine
> works, not a type of database file.
There's a flag stored in the database file. See under
"Persistence of WAL Mode" here:
http://www.sqlite.org/wal.html
___
Hi All,
I have developed some software that allows the user to change the schema of
tables. It does this by:
1. Backs up the rows from the old table into a temporary duplicate table
2. Drops the old table
3. Creates the new table
4. Inserts the rows from the duplicate into the new table
The SQL
On 7 Jan 2011, at 1:49pm, Sam Carleton wrote:
> The best way is to hard code SQLite source code
> to default to WAL all the time.
Okay. So do the experiment to find out what your copy defaults to now. For
all you know WAL mode /is/ the default.
Simon.
Simon,
>From what I gathered on the web site, WAL is a state of how the engine
works, not a type of database file. So the pragma needs to be set on each
connection. The issue comes from the fact the SQLite.net version of SQLite
is the destination for the logging system log4net. The log4net syste
26 matches
Mail list logo
