Some active and smart playlists--including built-in playlists such as "All Photo Files"--take a long time to open when they contain many files. Based on how long it takes, I'm guessing a SQL query is run each time. This makes the playlist smart or dynamic, but slow with large collections.

Using Views instead of queries should improve performance dramatically since the result set is stored and only refreshed as needed.