[mythtv-users] Record on Backend, Watch LiveTV on Frontend?

[Andy Davidoff]

The performance of either the DB or the encoder can negatively impact
interactive usability of the application.  As long as this is the case,
DB performance will be an issue that bears attention.

I agree that things should be done efficiently.  When the schema and
queries are designed carefully, SQL transaction "preening" is redundant.


On Apr 11, at 04:22, Bruce Markey encoded a 3.6K recording:
> I'm often surprised by the perception of database performance in
> MythTV. So, every once in a while, a tidbit of data is queried
> from the database. Then for an hour straight, 1.6GB of video is
> mpeg encoded in real time and written out, followed by an INSERT
> or something to mark that it's done. While things should be done
> efficiently, I don't think preening the SQL transaction needs to be
> the focus of performance tuning ;-).