Switching DB (MySql->MSSql) after install (1 Viewer)

[joystick]

MediaPortal Version: MP1.1 RC1
MediaPortal Skin: Streamed MP
Windows Version: XP SP3
CPU Type: Intel C2D 6550
HDD: 2 x Samsung 500GB, 1xSamsung 1TB
Memory: DDR2 3GB
Motherboard: AUSUS P5K-E WiFi AP
Video Card: His Radeon HD2600 XT
Video Card Driver: 8.11
Sound Card: Realtech onboard
Sound Card AC3: Optical out
Sound Card Driver:
1. TV Card: FireDTV
1. TV Card Type: DVB-C
1. TV Card Driver: latest stable
2. TV Card: Firedtv
2. TV Card Type: DVB-C
2. TV Card Driver: latest stable
3. TV Card: KNC-One
3. TV Card Type: DVB-C
3. TV Card Driver: latest stable
4. TV Card: KNC-One
4. TV Card Type: DVB-C
4. TV Card Driver: latest stable
MPEG2 Video Codec: PDVD 8
MPEG2 Audio Codec: PDVD 8
h.264 Video Codec: PDVD 8
Satelite/CableTV Provider: Kabel Deutschland
HTPC Case: Zalman HD160 incl. Irtrans
Cooling: Fan
Power Supply: Nesteq 500 Watts silent
Remote: Logitech Harmony 525
TV: Samsung Plasma 50''
TV - HTPC Connection: DVI->HDMI


Hi all,

first of all I would like to find out, if someone else experienced the same:
1) with Mysql setup Channel list (EPG) on remote clients is relatively slow compared to MSSQL
2) navigating through recordings on remote clients (not matter if Gigabit Net, or Wlan) is REALLY slow, like 5 -10sec to get any infomation, compared to MSSQL
Is there a setting that I missed in Mysql?

For the above mentioned points I would like to switch back to MSSQL,
I already installed/configured the Server, and copied my old database dirs.
I also changed the entry in gentle.config
Everything works, except that I cannot uninstall Mysql (because of the dependency to Tvserver) and "bind" the MsSql as dependency to the TVService.

has somene got a hint how to do that?

cheers + thx

joystick

 

[joystick]

AW: Switching DB (MySql->MSSql) after install

ok,
I fixed the change of DB systems myself.

this is what I did:

-I uninstalled the TVServer with the minimal options (leaving DB and config etc.)
- uninstalled Mysql
-I reinstalled TV Server and TV Plugin, and configured MSSQL as DB server

everything is working, and considerably fast, compared to Mysql...

cheers

joystick

 

[oekie]

I did the same. It's a lot faster and hopefully more reliable..
I had lots of probs with mysqll...