Totally depends on whom you ask.Isn't MSSQL slower and more sluggish than MySQL ? If not, i don't mind switching over if it fixes the problem...
There must another, simpler, way to fix this tho... :-(
as rtv mentioned, a fix from gibman seems to be the cause.Is this likely to be fixed without having to install MS-SQL tho ?
For large applications with multiple concurrent connections MySQL would be much faster than the express version of MS SQL, but this is quite a small database so I doubt there is much difference at all.Isn't MSSQL slower and more sluggish than MySQL ? If not, i don't mind switching over if it fixes the problem...
There must another, simpler, way to fix this tho... :-(
ALTER TABLE program ADD INDEX IdxProgramStartTime(startTime);
ALTER TABLE program ADD INDEX IdxProgramIdChannel(idChannel);