Philip Meyer;604528 Wrote: > >sqlite will be better for lower powered hardware, according to the > devs. > > > Based on what exactly? Better in what way? If it's better for > low-spec hardware, why wouldn't it be better for high-spec hardware? > Is there a linear performance comparison with all sizes of library? > Why isn't every DB on the planet powered by SQLite if it's the best?
ask the devs. i presume its less resource intensive, b/c SBS needs aren't so great as to require a full blown DB. Philip Meyer;604528 Wrote: > > >it will result in fewer software conflicts, according to the devs. > *Might* be true, but then again, it may cause more software conflicts. > MySQL has had some known issues, largely resolved by other app software > changes, rather than SBS changes. Who's to say that a SQLite solution > won't have similar/different conflicts? The solution does pretty much > the same thing. i assume the devs know what they are talking about. i am fairly sure the activity between two separate processes is what tripped up windef and some AV. Philip Meyer;604528 Wrote: > > >> > strawman. my point was about a separate mysql process. i have > seen > >> > the problems first hand. going to sqlite should, in theory, > help. > > > How does SQLite, in theory, help? again, ask the devs, i assume they know what they are talking about. as i just said, i believe that one process is less likely to raise red flags. Philip Meyer;604528 Wrote: > I did a quick Google, and found cases where Windows Defender/MSE was > causing software conflicts due to locking sqlite DB's, just the same as > the MySQL issue. Here's one example: > http://www.pubbs.net/201010/sqlite/8126-sqlite-antivirus-scannerwindows-lock-interference-problem.html > > >> > shall see. also, i didn't like how sbs would leave processes > running > >> > that were no longer needed when SBS was closed. > >> > > I don't think it does, by default, unless you have a problem. it did, and it may still. i raised a bug about it and it was fixed, but it seemed to recur now and then regardless. ur fight isn't with me, its with the devs. the devs seem to think sqlite is better, for various reasons some of which i have repeated. if you want answers as to why why why, ask them. for my part, having seen the current state of things, i am happy to see them attempt to address issues i have seen first hand, and since they know more about all this then i ever will, i afford them the benefit of the doubt. -- MrSinatra www.lion-radio.org using: sb2 & sbc (my home) / sbrec & ipeng (parents' home) - sbs 7.5.3b - win xp pro sp3 ie8 - p4(ht) 3.2ghz, 2gig ram - 1tb wd usb2 raid1 - d-link dir-655 - 45k+ mp3 ::VOTE FOR 'BUG 15604' (http://bugs.slimdevices.com/show_bug.cgi?id=15604)!!!:: ------------------------------------------------------------------------ MrSinatra's Profile: http://forums.slimdevices.com/member.php?userid=2336 View this thread: http://forums.slimdevices.com/showthread.php?t=84697 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
