[mythtv] Request: MythHelp

usleepless at gmail.com usleepless at gmail.com
Wed Feb 7 18:17:36 UTC 2007


Stuart, List,

On 2/7/07, Stuart Morgan <stuart at tase.co.uk> wrote:
> On Wednesday 7 February 2007 17:16, usleepless at gmail.com wrote:
> > > Just to note, removing those size()/isActive() calls will do nothing to
> > > improve performance or stability.
> >
> > no, but using postgresql might ( mysql blocking on locked tables ).
>
> I should point out the lock contention is not a mysql problem, but a MyISAM
> one. Other engines used by mysql, such as InnoDB don't have this issue.
>
> It's also fair to point out that many of the things people dislike about MySQL
> are simply aspects of MyISAM and shouldn't be confused.
>
> MyISAM is faster than postgre, but I've no idea how innodb compares. Innodb is
> slower than MyISAM but is designed with better data integrity and as it
> shares many features with postgre it may be comparable in speed.
>
> When it comes to mythtv, speed is often preferable.

i am patching svn files at the moment, and i just stumbled upon:
QString ChannelUtil::GetDTVPrivateType in channelutil.cpp.

there seems to be a bug there: query.next() is never called, even
though query.value(0).toString() is referenced.

regards,

usleep


More information about the mythtv-dev mailing list