home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
General Support
Slow DB Connection using MS SQL 2005
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="azimek" data-source="post: 356390" data-attributes="member: 45443"><p>Problem using mS SQL Server Express with MP TV Server and MP Client - multiseat.</p><p></p><p>In Configuration and in TV Client the system waits about 40 seconds when it tries to get the channels from SQL db:</p><p>LOG:</p><p></p><p>2009-01-07 18:48:01.985220 [Info.][Config Main]: get channels from database</p><p>2009-01-07 18:48:44.445660 [Info.][Config Main]: found:62 tv channels</p><p></p><p>This happens only on TC clients not on the server itself.</p><p>It seams that it takes 40 seconds to establish the dbconnection (monitored this using SQL Management studio)</p><p>The statement executed is:</p><p>(@idGroup int)select idGroup, groupName, sortOrder from ChannelGroup where idGroup = @idGroup;</p><p></p><p>Firewall and everything is set up OK. I don't get any errors - it's only the TIME PROBLEM - 40 seconds !!</p><p></p><p>Need help with this.</p><p></p><p>Server is RC4, clients are mixed RC4 an 1.0 - same problem on every system (except server).</p><p></p><p>Thanx André</p><p></p><p></p><p><strong>TV-Server Version</strong>: RC4</p><p><strong>MediaPortal Version</strong>: RC4</p><p><strong>MediaPortal Skin</strong>: BlueTwo3 Wide</p><p><strong>Windows Version</strong>: Vista 32bit SP1</p><p><strong>CPU Type</strong>: Intel QuadCore Q 6600</p><p><strong>HDD</strong>: </p><p><strong>Memory</strong>: 3GB</p><p><strong>Motherboard</strong>: ASUS</p><p><strong>Video Card</strong>: NVIDIA 8800GT 512mB</p><p><strong>Video Card Driver</strong>: latest</p><p><strong>Sound Card</strong>: on board SB Audigy</p><p><strong>Sound Card AC3</strong>: SB AC3 SPDIF to DENON Receiver</p><p><strong>Sound Card Driver</strong>: latest</p><p><strong>1. TV Card</strong>: FireDTV DVB-S2 mit Premiere</p><p><strong>1. TV Card Type</strong>: DVB-S</p><p><strong>1. TV Card Driver</strong>: latest</p><p><strong>2. TV Card</strong>: FireDTV DVB-S2</p><p><strong>2. TV Card Type</strong>: DVB-S</p><p><strong>2. TV Card Driver</strong>: latest</p><p><strong>3. TV Card</strong>: </p><p><strong>3. TV Card Type</strong>: </p><p><strong>3. TV Card Driver</strong>: </p><p><strong>4. TV Card</strong>: </p><p><strong>4. TV Card Type</strong>: </p><p><strong>4. TV Card Driver</strong>: </p><p><strong>MPEG2 Video Codec</strong>: MainConcept / DScaler</p><p><strong>MPEG2 Audio Codec</strong>: MainConcept</p><p><strong>h.264 Video Codec</strong>: MainConcept CoreAVC Pro</p><p><strong>Satelite/CableTV Provider</strong>: Astra Germany</p><p><strong>HTPC Case</strong>: DELL XPS 420</p><p><strong>Cooling</strong>: </p><p><strong>Power Supply</strong>: </p><p><strong>Remote</strong>: MCE IR and MS Keyboard IR</p><p><strong>TV</strong>: Panasonic PZ700E 50'' FullHD</p><p><strong>TV - HTPC Connection</strong>: HDMI</p><p></p><p>STRANGE !</p><p></p><p>I disabled TCPIP V6 on both vista systems (client and server) and now the connection time is only 25 seconds ?!?!?</p><p></p><p>Any suggestions</p></blockquote><p></p>
[QUOTE="azimek, post: 356390, member: 45443"] Problem using mS SQL Server Express with MP TV Server and MP Client - multiseat. In Configuration and in TV Client the system waits about 40 seconds when it tries to get the channels from SQL db: LOG: 2009-01-07 18:48:01.985220 [Info.][Config Main]: get channels from database 2009-01-07 18:48:44.445660 [Info.][Config Main]: found:62 tv channels This happens only on TC clients not on the server itself. It seams that it takes 40 seconds to establish the dbconnection (monitored this using SQL Management studio) The statement executed is: (@idGroup int)select idGroup, groupName, sortOrder from ChannelGroup where idGroup = @idGroup; Firewall and everything is set up OK. I don't get any errors - it's only the TIME PROBLEM - 40 seconds !! Need help with this. Server is RC4, clients are mixed RC4 an 1.0 - same problem on every system (except server). Thanx André [b]TV-Server Version[/b]: RC4 [b]MediaPortal Version[/b]: RC4 [b]MediaPortal Skin[/b]: BlueTwo3 Wide [b]Windows Version[/b]: Vista 32bit SP1 [b]CPU Type[/b]: Intel QuadCore Q 6600 [b]HDD[/b]: [b]Memory[/b]: 3GB [b]Motherboard[/b]: ASUS [b]Video Card[/b]: NVIDIA 8800GT 512mB [b]Video Card Driver[/b]: latest [b]Sound Card[/b]: on board SB Audigy [b]Sound Card AC3[/b]: SB AC3 SPDIF to DENON Receiver [b]Sound Card Driver[/b]: latest [b]1. TV Card[/b]: FireDTV DVB-S2 mit Premiere [b]1. TV Card Type[/b]: DVB-S [b]1. TV Card Driver[/b]: latest [b]2. TV Card[/b]: FireDTV DVB-S2 [b]2. TV Card Type[/b]: DVB-S [b]2. TV Card Driver[/b]: latest [b]3. TV Card[/b]: [b]3. TV Card Type[/b]: [b]3. TV Card Driver[/b]: [b]4. TV Card[/b]: [b]4. TV Card Type[/b]: [b]4. TV Card Driver[/b]: [b]MPEG2 Video Codec[/b]: MainConcept / DScaler [b]MPEG2 Audio Codec[/b]: MainConcept [b]h.264 Video Codec[/b]: MainConcept CoreAVC Pro [b]Satelite/CableTV Provider[/b]: Astra Germany [b]HTPC Case[/b]: DELL XPS 420 [b]Cooling[/b]: [b]Power Supply[/b]: [b]Remote[/b]: MCE IR and MS Keyboard IR [b]TV[/b]: Panasonic PZ700E 50'' FullHD [b]TV - HTPC Connection[/b]: HDMI STRANGE ! I disabled TCPIP V6 on both vista systems (client and server) and now the connection time is only 25 seconds ?!?!? Any suggestions [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
Slow DB Connection using MS SQL 2005
Contact us
RSS
Top
Bottom
