Re: [sqlite] Re: very slow inserts

Günter Greschenz wrote: hi, thanks for the quick answer :-) i always thought there is always an index for "rowid" ? thats the reason why i implemented it like this... i need to store a maximum amount of data in the database (e.b. max 10 entries or max 10 days) any idea how i could impleme

Re: [sqlite] Re: very slow inserts

hi, thanks for the quick answer :-) i always thought there is always an index for "rowid" ? thats the reason why i implemented it like this... i need to store a maximum amount of data in the database (e.b. max 10 entries or max 10 days) any idea how i could implement it in another way ? y

[sqlite] Re: very slow inserts

Günter Greschenz <[EMAIL PROTECTED]> wrote: 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%10=new.rowid%10 and