When I browse my library by Artist, after I select the artist (depending on the number of albums) I have to wait between 30 to 50 seconds before albums are displayed. I agree that I have quite a big library (11713 artists with 3516 albums) but this feels very slow. Do other shared db users have same issues?
I already checked forums and found some tweak settings. I applied the skip-name-resolve and modified the read_buffer_size = 256K in my.cnf for the Mysql server. Is there anything else I can do?
# The MySQL server
port = 3306
socket = /tmp/mysql.sock
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
If I would have to guess, it looks like there is no indexed link between artist and album in the db?
[/i]PS: when browsing in file mode, everything seems immediate
PS2: it first sight no problems are logged in the debug.log