Which database to install on TVserver? (1 Viewer)

[jcee]

From the tutorial videos I understand that MS SQL Express is the right one..

On the other hand I see the process named SQLSERVER.EXE under task manager growing up to 350MB after some days of operation, so I wonder whether this is right or wrong behaviour..

Maybe MSSQL is even not the best choice..


I cannot really belive that there is a process running on my HTPC which uses 350MB and its purpose is just to handle 50 recording, 100 channels and EPG information..

That looks like a BIG overhead...

Or am I doing things wrong?

 

[jcee]

No answer?

Does anyone know if this is normal? The SQLSERVER using 350MB in task manager?!

 

[dm15644]

You can limit the memory used by SQL Server 2005. See section "Limit SQL Server 2005 memory usage" in the Wiki http://wiki.team-mediaportal.com/TV-Engine_0.3/config-SQL-Server

/jayrock

 

[THDBASED]

Will this have any affect on performance?

 

[dm15644]

Generally speaking, if ressources are limited one can only overcome this by sacrificing performance. Still, compared to Windows swapping because it's running out of silicon memory I would guess it's more efficient to let SQL Server swap its data to HDD because SQL should have better estimates on what data is least likely to be required in the future.

(Assuming that MS have put some brains into the implementation of limiting memory usage on SQL Server.)

Note: The strict answer to your question is: I don't know.

/jayrock