[SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread michael123
I have about 16,000 files.. it took I think 2 hours at least (was about 45 minutes in 7.5.1) Can I help with something to profile that? CPU is 5-8%, mostly kernel time (obviously) -- michael123 michael123's Profile:

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread Phil Leigh
michael123;568981 Wrote: I have about 16,000 files.. it took I think 2 hours at least (was about 45 minutes in 7.5.1) Can I help with something to profile that? CPU is 5-8%, mostly kernel time (obviously) Why don't you switch to SQLite - it's much faster under 7.6 - and more

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread michael123
I read this: (pressing on 'i' on html page) Squeezebox Server supports SQLite and MySQL Server. SQLite is recommended for embedded systems and those with less memory, and also offers faster scanner performance. MySQL may offer better library browsing performance and is recommended for faster

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread Phil Meyer
Why don't you switch to SQLite - it's much faster under 7.6 - and more importanmtly it works :-) (yes I know Custom Scan won't work...) Is it really much faster? Does it really work? How can anyone tell, when: a) SQLite scanning doesn't work for some people b) MySQL doesn't work at all! Is it

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread Phil Leigh
Philip Meyer;569033 Wrote: Why don't you switch to SQLite - it's much faster under 7.6 - and more importanmtly it works :-) (yes I know Custom Scan won't work...) Is it really much faster? Does it really work? How can anyone tell, when: a) SQLite scanning doesn't work for some people

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread michael123
I will try SQLite, but anyway it is a severe (performance-related) regression bug, I opened http://bugs.slimdevices.com/show_bug.cgi?id=16460 BTW, I am using NAS (Lime unRaid) -- michael123 michael123's Profile:

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread Mnyb
On my CC4.2 linux installed with the rpm SQlite is the only working alternative with 7.6 . It also works really well, no scanning problems for me. On the other hand MySQl wont work at all -- Mnyb Main hifi: Touch + CIA PS

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread michael123
SQLite comleted in 40 min, about 5 minutes less than 7.5.1 on MySQL and 4 times faster than MySQL in 7.6.. So, what about MySQL in 7.6, why is it there, and why is it broken? -- michael123 michael123's Profile:

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread slate
Michael; to give the Squeeze-guys some background I think that you should add the following information to your bug report - your results using SQLite - describe your hardware and OS and maybe add the server and scanner logfiles -- slate Main: Duet - Beresford Caiman - Carver A-500x - BW

Re: [SlimDevices: Beta] Scanning in 7.6 in MySQL mode is so s-l-o-w...

2010-08-14 Thread michael123
slate;569070 Wrote: Michael; to give the Squeeze-guys some background I think that you should add the following information to your bug report - your results using SQLite - describe your hardware and OS and maybe add the server and scanner logfiles There was nothing special in the