[mythtv] add support for SQLite?

Kevin Kuphal kuphal at dls.net
Thu Mar 1 17:04:38 UTC 2007


usleepless at gmail.com wrote:
> 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.
>   
Nothing like threats to get your point across

Kevin


More information about the mythtv-dev mailing list