There's not much advantage in using relational databases for a cache; the whole point of using an SQL-based RDBMS would be to make it possible to do queries, a cache is just a flat information store for the most part, which at _most_ has a key of the original file. In either case, it's never going to be faster to use a DB to do something we would do using the filesystem which will almost definitely be faster.
A DB for the TV guide, I can see though. Aubin On Fri, Nov 28, 2003 at 06:55:00PM -0300, Gustavo Sverzut Barbieri wrote: > It's time to some backend storage to act like cache? > The problem is to find anything easy and suitable... sqlite seems to > don't handle large files... need to check > > Gustavo > > --- Dirk Meyer <[EMAIL PROTECTED]> escreveu: > > Sorry for the late answer. > > > > Aubin Paul wrote: > > > I would like to add embedded image extraction to mmpython; the idea > > is > > > pretty simple. Since id3v2 tags contain image data, we can write to > > > the mmpython cache, and then use that for cover data. > > > > I vote against it. If you look at the cache code, you will see that I > > took extra work to not cache the image thumbnails. The reason is > > simple. I have a directory with images from one vacation. When I > > enter > > this in Freevo, Freevo hangs for about 2 secs. This is bad, but it > > would be much worse if the cache contains the thumbnails. > > > > mmpython reads the pickled data from the cache. This takes some > > time. With image thumbnails in it, my vacation directory cache went > > up > > to 9 MB!. So adding mp3 images to it may not a good idea. > > > > > It would be easier to put right into Freevo, but not very clean. > > > > We have to think about that (also in the context of image > > thumbnails). Were to store the information that we have a > > thumbnail/cover? Were to put that cover? What should mmpython know, > > what should it cache? > > > > > > Dischi > > > > -- > > "I get to go to lots of overseas places, like Canada." - Britney > > Spears > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SF.net Giveback Program. > > Does SourceForge.net help you be more productive? Does it > > help you create better code? SHARE THE LOVE, and help us help > > YOU! Click Here: http://sourceforge.net/donate/ > > _______________________________________________ > > Freevo-devel mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/freevo-devel > > ______________________________________________________________________ > > Yahoo! Mail: 6MB, anti-spam e antiv?rus gratuito! Crie sua conta agora: > http://mail.yahoo.com.br > > > ------------------------------------------------------- > This SF.net email is sponsored by: SF.net Giveback Program. > Does SourceForge.net help you be more productive? Does it > help you create better code? SHARE THE LOVE, and help us help > YOU! Click Here: http://sourceforge.net/donate/ > _______________________________________________ > Freevo-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/freevo-devel ------------------------------------------------------- This SF.net email is sponsored by: SF.net Giveback Program. Does SourceForge.net help you be more productive? Does it help you create better code? SHARE THE LOVE, and help us help YOU! Click Here: http://sourceforge.net/donate/ _______________________________________________ Freevo-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/freevo-devel
