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, 2010 at 3:00 PM, Oliver Peters <oliver....@web.de> wrote: > Durga D <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 > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
