Re: [sqlite] is primary key already indexed ?

On Thu, 19 Mar 2009 06:38:33 -0700 (PDT), baxy77bax wrote: >:-D > >one more question : > >if i create primary key on my table and then import the data (assuming i >used transactions) will my import be faster or slower vs the case where i >import the data first and then create

Re: [sqlite] is primary key already indexed ?

nop no i ment up to 50 MB an these are tough to import(i just wanted to mention that because on these records import is slownig down and it is not so fast any more example if i import one set of data that is small and the other that is large the overall time is T1= t1 +t2 but if i mix those

Re: [sqlite] is primary key already indexed ?

On Mar 19, 2009, at 9:38 AM, baxy77bax wrote: > > > :-D > > one more question : > > if i create primary key on my table and then import the data > (assuming i > used transactions) will my import be faster or slower vs the case > where i > import the data first and then create key (foreign

Re: [sqlite] is primary key already indexed ?

:-D one more question : if i create primary key on my table and then import the data (assuming i used transactions) will my import be faster or slower vs the case where i import the data first and then create key (foreign key ??) and index the table. the point is that i need my import to be

Re: [sqlite] is primary key already indexed ?

:-D one more question : if i create primary key on my table and then import the data (assuming i used transactions) will my import be faster or slower vs the case where i import the data first and then create key (foreign key ??) and index the table. the point is that i need my import to be

Re: [sqlite] is primary key already indexed ?

On Thu, 19 Mar 2009 02:54:34 -0700 (PDT), baxy77bax wrote: > >hi my question is : if i create table that contains primary key like; > >create table TEST (field1 varchar not null primary key); > >do i need to create index on it or not? No, the primary key implies an index will

Re: [sqlite] is primary key already indexed ?

Hi,. baxy77bax schrieb: > hi my question is : if i create table that contains primary key like; > > create table TEST (field1 varchar not null primary key); > > do i need to create index on it or not? > Yes, the primary key is indexed > and is it better to create table with a primary key and