Which is faster MS SQL OR MYSQL server (1 Viewer)

[CrashUK]

Hi

I runing mediaportal with 900+ channels when adding new recording they is a delay.. This due to sql server so I was thinking if I use a faster sql this could speed things up. Does any using microsoft SQL server and is it any faster.

 

[Vasilich]

delay when adding new recording is currently because of unoptimized accesses to DB. It depends on number of channels, number of existing schedules, number of TV Tuners etc. There is a patch that greatly improves this (in my case from 25 seconds to 3-4 seconds), but it will be included (hopefully) in later versions of MP (1.2.1 or 1.3). So don't hope to get it faster with changing DB engine.

 

[CrashUK]

delay when adding new recording is currently because of unoptimized accesses to DB. It depends on number of channels, number of existing schedules, number of TV Tuners etc. There is a patch that greatly improves this (in my case from 25 seconds to 3-4 seconds), but it will be included (hopefully) in later versions of MP (1.2.1 or 1.3). So don't hope to get it faster with changing DB engine.

25 sec to 3-4 thats a big speed up.. Do you have a link to the patch.

 

[Vasilich]

i will post it tonight as i changed there small things suggested by other team members...