Re[2]: [sqlite] Sqlite low level and Speed.

[Yuriy]

BV> use transactions, speeds up a lot
Sorry transaction i also use speed low :(

begin
c:=0;
for i:=1 to 10000000 do
begin
select * from testable where  val=StringN
if val NOT Exist  insert into testtable

 inc(c);
  if c=10000 then
      begin
      Commit;
      Begin;
      c:=0;
      end;

end

commit

-- 
Best regards,
 Yuriy                            mailto:[EMAIL PROTECTED]