Reply to thread

Message

1) Using SQL Server has nothing to do with server / client possibilities. At best it is a very loosely related concept. At the enterprise level, SQL Server would bring a big advantage with it's ability to better handle concurrent transactions. At the level MediaPortal operates (3-5 clients), it is totally irrelevant.

2) The speed of the database is really just not an issue. As the lead developer of Moving Pictures, I have never once heard a complaint about speed of the plugin where the database was the bottle neck. In my experience, online web services (like IMDb, Movie-XML, etc) and file system access (like files on a network drive) are the real slow downs. Database access with SQLite is generally fairly snappy.

3) Not all users use TV Server 3 or have SQL Server already installed. According to the last user survey, 26% of people don't even use the TV features of MediaPortal. This means that for those people, they would have to specifically install SQL Server for TV Series. This complicates the user experience. It makes it harder to begin using the plugin.

Ultimately I see at least one down side and no advantage...

<blockquote data-quote="fforde" data-source="post: 424021" data-attributes="member: 52082">1) Using SQL Server has nothing to do with server / client possibilities. At best it is a very loosely related concept. At the enterprise level, SQL Server would bring a big advantage with it's ability to better handle concurrent transactions. At the level MediaPortal operates (3-5 clients), it is totally irrelevant.2)&nbsp; The speed of the database is really just not an issue. As the lead developer of Moving Pictures, I have never once heard a complaint about speed of the plugin where the database was the bottle neck. In my experience, online web services (like IMDb, Movie-XML, etc) and file system access (like files on a network drive) are the real slow downs. Database access with SQLite is generally fairly snappy.3) Not all users use TV Server 3 or have SQL Server already installed. According to the last user survey, 26% of people don't even use the TV features of MediaPortal. This means that for those people, they would have to specifically install SQL Server for TV Series. This complicates the user experience. It makes it harder to begin using the plugin.Ultimately I see at least one down side and no advantage...</blockquote>

[QUOTE="fforde, post: 424021, member: 52082"] 1) Using SQL Server has nothing to do with server / client possibilities. At best it is a very loosely related concept. At the enterprise level, SQL Server would bring a big advantage with it's ability to better handle concurrent transactions. At the level MediaPortal operates (3-5 clients), it is totally irrelevant. 2) The speed of the database is really just not an issue. As the lead developer of Moving Pictures, I have never once heard a complaint about speed of the plugin where the database was the bottle neck. In my experience, online web services (like IMDb, Movie-XML, etc) and file system access (like files on a network drive) are the real slow downs. Database access with SQLite is generally fairly snappy. 3) Not all users use TV Server 3 or have SQL Server already installed. According to the last user survey, 26% of people don't even use the TV features of MediaPortal. This means that for those people, they would have to specifically install SQL Server for TV Series. This complicates the user experience. It makes it harder to begin using the plugin. Ultimately I see at least one down side and no advantage... [/QUOTE]