andyg;648906 Wrote:
> The performance can be improved by enabling exclusive locking again,
> I'll look at this once there are no other WAL issues.
>
What was the purpose of introducing WAL ?
I thought the main reason was to get rid of the "database is locked"
issues ? Won't enabling exclusive locking make them return again ?
If so, my personal feeling is that it's not worth risk introducing
"database is locked" issues by enabling exclusive support if we are
only talking about a full scan performance slow down of 10-20% in a 50
000 track library. As someone said in another thread, it's better to
fix the performance in 7.6.2.
I suspect the reason JJZolx sees bigger difference between 7.5.6 and
7.6.1 is because he uses a more optimized MySQL configuration then the
one selected with "High" in SBS Settings/Advanced/Performance which I
used. Or it could be related to that he used a later MySQL version than
5.0.21 which is distributed with SBS or that he is using Windows, but I
suspect it's related to the MySQL configuration which makes MySQL scale
better in larger libraries.
--
erland
Erland Isaksson ('My homepage' (http://erland.isaksson.info))
(Developer of 'many plugins/applets'
(http://wiki.slimdevices.com/index.php/User:Erland). If my answer
helped you and you like to encourage future presence on this forum
and/or third party plugin/applet development, 'donations are always
appreciated' (http://erland.isaksson.info/donate))
------------------------------------------------------------------------
erland's Profile: http://forums.slimdevices.com/member.php?userid=3124
View this thread: http://forums.slimdevices.com/showthread.php?t=89513
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
