[mythtv] add support for SQLite?

Steven Adeff adeffs.mythtv at gmail.com
Thu Mar 1 15:52:49 UTC 2007


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.

-- 
Steve
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette


More information about the mythtv-dev mailing list