postgresql

[stianfp]

hi, is subsonic using H2 as db? I have been using mytunesrss for a long time now, and found out very quickly, postgresql is much quicker then both H2 and mysql, when it comes to a big music collection (250k+). Does subsonic support the use of postgresql? Did not find anything on the forum or on your site about it. If it does, could you write a howto?

[sindre_mehus]

Hi,

Subsonic uses an in-process HSQLDB. Switching to another database would require at least one code change, but is probably doable. There's no howto available, but if anyone wants to have a go, start by looking in the class net.sourceforge.subsonic.dao.DaoHelper.

Note, however, that Subsonic doesn't store metadata about tracks in the database, so performance is probably not a big issue. That said, I'm hoping to do some profiling soon to iron out potential application bottlenecks.

Sindre