erland;231390 Wrote: > In Custom Scan which is responsible for storing the data it is pretty > simple to do what ever we want. So there is no problem storing the data > in separate id/value tables. > > The problem is to update all the existing playlist and browse menus > that use the current structure. I would guess that we are talking about > rewriting maybe 50-100 SQL statements. The rewrite will probably go > pretty fast since most of them look similar, but the thing that takes > time is testing it. > > So I guess that what I'm saying is that it should be resonable to test > this with one or two playlists/menus and then make the big change when > we know what works. >
I understand the problem. That's why before diving into the code it would be better to run test queries and validate the improvement worse the labor. This looks like tricky evolution and as there is lot of code/queries involved, we (maybe i rather say 'you' ;) ) have to be sure this is the best solution. erland;231390 Wrote: > > But as I said in my previous post, I think it is probably a bigger > chance that dividing the tables per attribute is going to improve > things so I like to start with that. If it doesn't help, I can try to > separate them into id/values. Separating into both attributes and > id/values is going to result in a a lot of tables for some people, but > I guess this isn't a real problem. > > Handling database upgrades will also be challenge when I don't know > what tables exists, but that could be a fun thing to solve. Both changes are compatible, first we can divide tables (divide et impera), then if it's not enough, export string values to "string value,id" tables. Hum, enough sql headache for today, let's get back to my xml problems... -- vrobin ------------------------------------------------------------------------ vrobin's Profile: http://forums.slimdevices.com/member.php?userid=11705 View this thread: http://forums.slimdevices.com/showthread.php?t=38714 _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/plugins
