Re: [sqlite] String field as primarykey

2010-10-12 Thread Durga D 
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 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

Re: [sqlite] String field as primarykey

2010-10-12 Thread Durga D 
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  wrote:

> 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

Re: [sqlite] String field as primarykey

2010-10-12 Thread Oliver Peters 
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] String field as primarykey

2010-10-12 Thread Durga D 
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 there.

  Is there anyway to optimize this?

  Requirement: Insert 100,000,000 records.

Thanks and Regards,
Durga.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users