[mythtv] add support for SQLite?

James Chapman jchapman at katalix.com
Sat Mar 3 15:53:48 UTC 2007


Michael T. Dean wrote:
> On 03/02/2007 06:55 PM, Paul Harrison wrote:
>> James Chapman wrote:
>>   
>>> Paul Harrison wrote:
>>>     
>>>> James Chapman wrote:  
[snip]
>>> Which functions of MythTV create most load on the database?
>>>     
>> I don't really know the answer to this. Possibly anything that queries 
>> the program table like the EPG or running mythfilldatabase generates 
>> lots of queries.
> 
> Besides, if you're really interested in getting away from the separate 
> MySQL installation/configuration, why not help out with the 
> testing/effort to move to embedded MySQL?  I'm pretty sure you'll be 
> able to find some people with some good info (i.e. that may have gone a 
> good ways down the embedded MySQL road) on Myth's IRC channels.

My motivation for trying SQLite isn't to avoid a separate database, it's 
to reduce filesystem/memory footprint. If SQLite was abandoned only for 
performance reasons, I'm happy to spend time integrating it and then 
profiling/analyzing the resulting system to improve performance.

Thanks for pointing me at the IRC channels. I'll try to reach people there.

-- 
James Chapman
Katalix Systems Ltd
http://www.katalix.com
Catalysts for your Embedded Linux software development



More information about the mythtv-dev mailing list