subject:"\[sqlite\] question regarding Check\-in \[3671\]\:"

Re: [sqlite] question regarding Check-in [3671]:

2007-03-06 Thread drh

[EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > What sort of SQL statements will benefit most from this change? > > SQL statements that run on embedded platforms that lack a > OS filesystem cache. > I'm back at my office now and able to run some speed trials. It appears

Re: [sqlite] question regarding Check-in [3671]: Changes to the btree and pager that reduce the amount of I/O when dealing with the freelist.

2007-03-04 Thread drh

Joe Wilson <[EMAIL PROTECTED]> wrote: > What sort of SQL statements will benefit most from this change? SQL statements that run on embedded platforms that lack a OS filesystem cache. -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] question regarding Check-in [3671]: Changes to the btree and pager that reduce the amount of I/O when dealing with the freelist.

2007-03-04 Thread Joe Wilson

What sort of SQL statements will benefit most from this change? Large delete operations or vacuum? What about query speed? Bored stiff? Loosen up... Download and play hundreds of games for free on Yahoo!