On 5/31/05, Jason Tackaberry <[EMAIL PROTECTED]> wrote: > On Tue, 2005-05-31 at 17:44 +0200, Martijn Voncken wrote:
> A faster approach would be a hybrid. You use media-specific tables for > the common stuff. And user- or application-created metadata can be put > into a metadata table. At least then common queries can benefit from > the speed of the filetype-specific tables. But the added design > complexity might not justify that. > I'm willing to change to a design with EMPTY hybrid tables. *It will really speed up initial development. (compared to full hybrid right away) *common api's will remain the same. *if testing/application requires more performance,a switch to hybrid is still possible. > I did some tests on this a while ago, and at the time I decided that the > single metadata table wasn't fast enough. But I've learned a few more > things since then. I think I'll have to redo the tests and see the > results again. Yes, do that tests. query's on 2 or more attributes will/can be slow. But how common are they in freevo now? About the sqlite-limit discussion on IRC: http://pastebin.ca/13032 Martijn. ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ Freevo-devel mailing list Freevo-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freevo-devel
