[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