> I'm not sure what you are getting at here. Copy memory from
> where to where? The database is much more than an array of
> record structures that you can copy data into.
>
> Dennis Cote
I've been studying the profile and can see my thinking was wrong. I was
thinking we would just log an ins
Brannon King wrote:
So I dropped the "not null" and it gave a ~2% increase in overall speed.
It's not much, but may count for something. It's a little strange because
that is just the opposite of MySQL. In MySQL, it shrinks the database size
and speeds up the access by declaring a column not null
On 5/18/06, Brannon King <[EMAIL PROTECTED]> wrote:
>Also, do a large number of inserts within a transaction. (1000-100,000 or
so, not a billion ;) )
I don't see how increasing the number of inserts per transaction changes the
speed at which the sqlite3_step function executes when it is called o
So I dropped the "not null" and it gave a ~2% increase in overall speed.
It's not much, but may count for something. It's a little strange because
that is just the opposite of MySQL. In MySQL, it shrinks the database size
and speeds up the access by declaring a column not null.
I am using the pre
>Also, do a large number of inserts within a transaction. (1000-100,000 or
so, not a billion ;) )
I don't see how increasing the number of inserts per transaction changes the
speed at which the sqlite3_step function executes when it is called on an
insert in the middle of the transaction. I'll put
Brannon King wrote:
Or is an Index sufficient?
Brandon,
Having a primary key is the same thing as adding a UNIQUE index on the
desired columns except for the case where the key is on a single column
with integer type (i.e. integer primary key). The later case is
optimized in sqlite, but mus
On 5/18/06, Brannon King <[EMAIL PROTECTED]> wrote:
As I understand SQL, "alter table blah add primary key (blah1, blah2)"
should be how you do it. The sqlite documentation seems to say
otherwise. Actually, I cannot figure out from the documentation how to
add a primary key after the table is cre
As I understand SQL, "alter table blah add primary key (blah1, blah2)"
should be how you do it. The sqlite documentation seems to say
otherwise. Actually, I cannot figure out from the documentation how to
add a primary key after the table is created and data is entered. How is
it done? Or is an
8 matches
Mail list logo
