Subscribe via rss
Guest
or Ask a Question
Discussions
Add a reply View Replies (4)

Optimizing the database for large playlists.

Suggestions
Saturday, August 25 2012, 11:30 PM
Rickard Löwgren
Rickard Löwgren
Offline
0
Hi.

I think it would be a good thing to perhaps change the playlist tables field "songs" to at least "mediumtext" to support large playlists.

The standard field type is limited to 255 chars if i am not mistaken, this limits the playlists from growing.

!!!Warning!!!
Changing the field type might result in data loss on that field.
Responses (4)

  • Accepted Answer

    Germinal Camps
    Germinal Camps
    Offline
    Sunday, August 26 2012, 04:16 PM - #Permalink
    0
    yes it's not a bad idea if you plan to have large playlists..

    have you tried to change it?
    The reply is currently minimized Show

  • Accepted Answer

    Dardis Intel
    Dardis Intel
    Offline
    Wednesday, January 23 2013, 06:25 PM - #Permalink
    0
    Has there been any new developments on this?
    The reply is currently minimized Show

  • Accepted Answer

    Rickard Löwgren
    Rickard Löwgren
    Offline
    Wednesday, January 23 2013, 06:59 PM - #Permalink
    0
    Yeah. i changed the value and it worked like a charm.

    It might be a good idea to make this a standard for future updates.
    The reply is currently minimized Show

  • Accepted Answer

    Dardis Intel
    Dardis Intel
    Offline
    Wednesday, January 23 2013, 07:02 PM - #Permalink
    0
    Oh good. Can you tell me what values you use when editing the playlist table? What values do you insert into the playlist table to store them on the db?
    The reply is currently minimized Show
Your Reply