[mythtv] MythMusic database schema suggestion

Brian Lalor blalor at bravo5.org
Tue Jun 24 16:06:52 EDT 2003


Matt Zimmerman wrote:
> On Tue, Jun 24, 2003 at 12:16:59PM -0700, Chris Petersen wrote:
> 
> 
>>on that note, many smaller DB queries are a much more efficient option
>>than loading the whole thing into memory
> 
> 
> Not when you need all (or most) of the records anyway.

I'm gonna go out on a limb here and say that you *never* need all (or even 
most) of the records, unless you've got a playlist with all of the tracks in 
the database in it, and even then its just one query.  Otherwise you're just 
wasting memory.

-- 
    __   ____
   / /  / __/ Brian Lalor
  / _ \/__ \  blalor at bravo5.org
/_.__/____/  http://bravo5.org/


More information about the mythtv-dev mailing list