Re: [sqlite] Sqlite low level and Speed.

[Jay Sprenkle]

On 6/20/05, Yuriy <[EMAIL PROTECTED]> wrote:

> 1. Example of the decision
> 
> CREATE TABLE testtable (val text)
> CREATE INDEX index_val ON [testtable]([val]);
> PRAGMA synchronous = OFF;
> 
> for i:=1 to 10000000 do
> begin
> select * from testable where  val=StringN
> if val NOT Exist  insert into testtable
> end
> 
> Very Slow.

for i:=1 to 10000000 do
begin tran
insert or on conflict fail into testtable(val) values(StringN);
commit
end for