Re: [sqlite] String field as primarykey

journal file is creating between transactions. On Tue, Oct 12, 2010 at 3:00 PM, Oliver Peters wrote: > Durga D writes: > > [...] > > > But performance issue is there. > > > > Is there anyway to optimize this? > > > > > maybe you should try > > PRAGMA

Re: [sqlite] String field as primarykey

Hi Oliver, Thank you for your prompt response. I am using C++ wrappers in VC++ 8.0 applicaiton. Where should I add PRAGMA? And also when I insert 100k records by using statement, "m_oDB.execDML(strQuery);" virtual memory is keep on increasing. Any idea? Durga. On Tue, Oct 12,

Re: [sqlite] String field as primarykey

Durga D writes: [...] > But performance issue is there. > > Is there anyway to optimize this? > maybe you should try PRAGMA journal_mode = OFF; Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] String field as primarykey

Hi All, I have created a sqlite database with "create table EMP (F1 INTEGER ,F2 TEXT(1120) primary key collate nocase,F3 INTEGER ,LMD TEXT(1120) ,F4 TEXT(1120) ,F5 TEXT(1120));". Here F2(Field2) is primary key. I used transaction queries for every 25,000 records. But performance issue is