hi everybody,
i have the following problem:
i've created this table and trigger (no index !):
CREATE TABLE msgs (date ntext, type ntext, dir ntext, s integer, f
integer, msg ntext);
CREATE TRIGGER delete_log after insert on msgs begin delete from
msgs where rowid%100000=new.rowid%100000 and rowid!=new.rowid; end;
my database is filled with about 40000 rows and is about 265mb in size.
the problem now is: sometimes (only sometimes !!!) inserting into this
table is very slow:
---------- this took 59.098 sec:
insert into msgs values ('8/2/2007 4:41:00 AM', 'Primary', 'Out', 5, 1, 'L
ALCD B: ''129'' = WARNING_ON (bit 8 set, class=1 (warning))
ALID U4: ''2159''
ALTX A[80]: ''PM01.M06.1.Gas_07.FlowDeviation.Warning_warning''
ALTM A[14]: ''20070802044059''
MODULEID A[27]: ''8ACBI01_IS01_SP01'' = EQP (Basic Equipment)
'
---------- this took 72.251 sec:
insert into msgs values ('8/2/2007 8:31:05 AM', 'Primary', 'Out', 5, 1, 'L
ALCD B: ''130'' = ERROR_ON (bit 8 set, class=2 (error))
ALID U4: ''714''
ALTX A[80]: ''AM01.M02.1.FLT_DRIVE_1_alarm''
ALTM A[14]: ''20070802083103''
MODULEID A[27]: ''8ACBI01_IS01_SP01'' = EQP (Basic Equipment)
'
----------
any idea why its sometimes so slow ?
as programming language is use c# (.net 2.0), as db-layer i use
"System.Data.SQLte.dll" (v1.0.44.0)
(before i forget it: i dont use transactions while inserting data !)
thankx, gg
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
