--- Jay Sprenkle <[EMAIL PROTECTED]> wrote: > On 4/28/06, Joe Wilson <[EMAIL PROTECTED]> wrote: > > No, exactly the opposite. > > I want to expose my data structures and methods to the SQLite engine > > to leverage its advanced ad-hoc querying abilities without the need > > to commit my data to the database. > > Ah. I assume the data will get saved eventually, > so doesn't this simplify to a cached database?
The data in the case I described is all transient, but stored in my application's memory in a very dense format with various C functions to extract individual fields. To mirror that same data to conventional SQLite tables - even in an in-memory database - would easily make my server's memory footprint ten times bigger. This is why the Virtual Table Proposal is so useful - in my opinion, much more useful than full-text-search which it was inspired by. :-) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
