wow! it should be that slow. in WHICH table?

maybe the problem is simply that your PAGINATION number is "all".

is this the case? bad idea!! make it 50 or so! it will load fast as lightning...

Where is the pagination setting? I only see a radio select for "use pagination for artist view" in the main page tab...no option for setting it to 50?

no, pagination is not that, is the length of the list, on the backend, on the albums/artist/songs view. if it's not a number (but "all") the query will take forever! just load it once (wait a bit...!) and then change the number to 50.

Hmm..I am not following you. Can you please be more specific...sorry for not understanding.

I figured out what you were saying...in the bank end, on the actual songs, album and artists management interface...all of those are set to 20 not all?

Also why would this effect the front end loading slowly? I can go to the songs management interface and load a page, it takes time...however cannot access the muscol homepage...takes much longer than five minutes to load?

can you please send me a link?

I have had the exact same problem in the past. I originally bought this app with the idea I could stream all my music collection from anywhere and have a nice pretty app where I could add stuff like bio and reviews and what not. I ran into the exact same problem. I wanted to import my full collection via a sql script, but unfortunately anything over about 10k songs would just bog down to the point it was painfully slow and non useable. I tried to put my full collection of 300k+ songs at that time and it would not even load, lol. MC just does NOT scale well

I ended up having to scrap using MC for what i originally purchased it for. I now use it for just a single artist website as I do not expect to hit over 1k songs anytime soon. Nor do I have to rely on auto id3 tag reading, or smart playlist creation, which are features becoming standard in most other apps.

I use ampache.org for my streaming. It loads songs nearly instantly. It does not use direct linking of songs. And access can be controlled via password and user sessions. It only takes about 1 run of 24 hours to scan in my whole collection and it can read the id3 tags, filenames, and folder names, as well as grab the artwork, so no long manual adding of albums. It also allows me to do smart playlists, so i can add songs by genre, rating, artist, etc, instead of having to add them one at a time. And best of all its free.

The biggest downfall, is it does not have all the pretty templating that joomla has, nor does it have some of the eye candy like artist images, bios, reviews, etc. But for a site that only a few can access via a login, it works great!

I have had to advice any of my users who are looking to purchase a music component to define exactly what they need. For large libraries, especially for just personal streaming, i recommend ampache, or occasionally subsonic if they want to go the java route. For smaller collections where its more about the eye candy then the functionality, i will typically point them to MC, especially if they are already using joomla.

say its not true...

@checkone: you had the options "show artists on homepage" and "do not use pagination on homepage"!! this is crazy. of course it didn't load. I changed that.
besides of that they may be some issues with such big database tables. only thing I can suggest is to index some columns.
I have to point out that maybe your MySQL server is a bit slow.. I mean, here in this site we have 20k+ songs and it runs well...!

now, if you have access to your mysql database, could you try this?

please, INDEX the column "artist_id" on the table jos_muscol_albums and on the table jos_muscol_songs

also INDEX the column "album_id" on table jos_muscol_songs

do you know what I mean? can you try that?

in other words, execute this on your MySQL:

ALTER TABLE `jos_muscol_albums` ADD INDEX ( `artist_id` )
ALTER TABLE `jos_muscol_songs` ADD INDEX ( `album_id` )
ALTER TABLE `jos_muscol_songs` ADD INDEX ( `artist_id` )
ALTER TABLE `jos_muscol_artists` ADD INDEX ( `letter` )

please, if you table prefix is not jos_ just use yours.

does this improve performance?

Thanks man...that worked! It was set to show all by default...the indexes worked perfect.

Hi Germi,

I've been looking into this as well as my site gets slower and slower
Next to the above I'm wondering about the stats module... looking at my DB i already got 3.1 million!! entries there. Now i did turn of some stats tracking options a minute ago to see if that changes performance. Is there a way to improve performance on this part?

hello!

1. have you executed the indexing queries on MySQL? to make the Music Collection go faster.
2. 3.1 milion is really a lot. I didn't know you had so many visitors! turning some of them down is a very good thing, but most important: you should clean up that table.
think this: what data you really use back in time? maybe 1 month? my suggestion is that you delete all entries previous to, for instance, last month (or whatever is good for you)

do you know what I mean?

NOTICE: if you do this, since it's a big query, it could take a while to be done. I mean, the query could take maybe up to 5 or 10 minutes to execute (just so you know!)

Germi,

I did step 1 but i'm really sure that made a difference for me as its still quite slow


For point 2....Is there a way to keep 'album views' stats... as those are really the one im interested in. I would love to keep my record for that, all other stats can be removed...

I'm no MYSQL guy.... got a comment i can execute? or maby have a look for me?

All i can do is empty the complete table..lol

I emptied it... i'll get my stats all over again from now on... seems like an improvement, scans show the site quicker.