[mythtv] add support for SQLite?

[usleepless at gmail.com]

On 3/1/07, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
> On 2/28/07, usleepless at gmail.com <usleepless at gmail.com> wrote:
> > On 2/28/07, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
> > > On 2/28/07, Paul Harrison <mythtv at dsl.pipex.com> wrote:
> > > > James Chapman wrote:
> > > > > Hi,
> > > > >
> > > > > I was considering working on support for SQLite but the wiki suggests it
> > > > > will never work. Anyone have more details?
> > > > >
> > > >
> > > > There was some testing done about a year ago by Isaacs brother looking
> > > > at the possibility of using SQLite but the conclusion was it was just
> > > > two slow compared to MySQL. The main scheduler query was almost 6 times
> > > > slower. It was thought that the reason was because it only supports one
> > > > index per table and in mysql, it's using indexes for almost everything
> > > > in that big query. That was the status as of April last year not sure if
> > > > anything has changed in the meantime?
> > >
> > > I wonder if the SQL cleanup will affect this in any way?
> >
> > SQL cleanup?
> >
> > where? when? what? who? why?
>
> sorry, ticket #3060/3061
>
> but I don't think it will, it doesn't look to lower the database hits
> in the right place.

no it won't. but i will not continue to supply sane patches if this
one isn't being committed. the scheduler code is not in libmythtv
anyway, and that's where i started.

the scheduler query in itself needs work. i have been reading
it/thinking about it for some time now, not sure on what to do yet.

regards,

usleep