[mythtv-users] Mythfilldatabase taking FOREVER

[Larry Kennedy]

On Mon, Jun 13, 2022 at 10:35 PM Gary Buhrmaster <gary.buhrmaster at gmail.com>
wrote:

> On Tue, Jun 14, 2022 at 1:52 AM Larry Kennedy <lunchtimelarry at gmail.com>
> wrote:
>
> > On second look, queries are slow too.  Select from Person can take
> upwards of 400ms:
>
> When was the last time you performed a key distribution
> analysis and stored the statistics for use by the query
> optimizer?
>

Gary, I've got the optimize_mythdb script set up to run periodically.  So,
it ran very recently.


> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20220614/ca079e1b/attachment.htm>