Is it difficult to upgrade the SQLite libraries to the latest? Any potential downside?
I've always said that I believe performance improvements could be had in both the design of the database and in its use. For example, my suggestion of every album having a contributor or contributors in the ALBUMARTIST role would speed up the generation of album lists. This could be had at a very slight increase in scanning time. I also believe that minimizing the use of NULL values in the database would yield performance improvements. These are everywhere, and the proper way prevent them and find out where they're being used would start with redefining many columns in the database tables as NOT NULL. ------------------------------------------------------------------------ JJZolx's Profile: http://forums.slimdevices.com/member.php?userid=10 View this thread: http://forums.slimdevices.com/showthread.php?t=101248 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
