[mythtv-users] mythweb: slow results from mythweb/tv/recorded page

[jack snodgrass]

On 9/27/06, Chris Petersen <lists at forevermore.net> wrote:
> jack snodgrass wrote:
> > The query:
> > http://web-server/mythweb/tv/recorded
> > takes over 3 minutes to complete with my 75 shows.
>
> What version of mythweb?
>
> > I have my own custom query that returns title, time, subtitle, etc info on the
> > same 75 shows and the query completes in .5 seconds.
>
> It's a lot of queries, and a handful of checks against the requested
> recording schedules (talking to the backend, etc).
>
> mythweb version will make a huge difference, though.  We made some huge
> speed improvements in .20
>
> -Chris

sorry.... I just assume that everyone is running from a semi-recent svn
version. ;) It's been slow like this for as long as I remember. I'm running
from a week-old svn ( after .20 was released ) version.

tv listings and upcomming recordings take .7 and .8 seconds to
complete. Everything is generally speedy ( the backend with the
mysql server / web server  is a 3800+ x2 amd64 with 2gig of memory
and the front end is a 4600+ x2 amd64 with 2gig of memory )  execept
for the recorded shows... I definitly notice .7 secons -vs- 3 minutes.
When I want to see what's been recorded, I have to go get coffee.

both the frontend and backend are up-to-date Fedora FC5 installations.
mysql was installed from the RPMs.

I do notice messages on the backend.... when I run this web page....

2006-09-27 18:27:36.465 Preview Error: Previewer could not open file:
'file not found'
2006-09-27 18:27:36.465 MainServer: Failed to make preview image.
2006-09-27 18:27:36.467 MainServer::HandleAnnounce FileTransfer
2006-09-27 18:27:36.472 adding: websrvr as a remote file transfer
2006-09-27 18:27:42.976 RingBuf(/mnt/store//file not found.png): Could
not open /mnt/store//file not found.png.
2006-09-27 18:27:42.985 MainServer::HandlePixmapLastModified() -
Couldn't find backend for:   : " "
2006-09-27 18:27:42.986 MainServer::HandleGenPreviewPixmap()
                        Couldn't find backend for:
                          : " "
2006-09-27 18:27:43.488 RingBuf(file not found): Could not open file not found.
[root at fw logs]# tail mythbackend.log  -n100
2006-09-27 18:26:34.247 RingBuf(file not found): Could not open file not found.
2006-09-27 18:26:34.252 Preview Error: Previewer could not open file:
'file not found'
2006-09-27 18:26:34.252 MainServer: Failed to make preview image.
2006-09-27 18:26:34.254 MainServer::HandleAnnounce FileTransfer
2006-09-27 18:26:34.254 adding: websrvr as a remote file transfer
2006-09-27 18:26:40.755 RingBuf(/mnt/store//file not found.png): Could
not open /mnt/store//file not found.png.
2006-09-27 18:26:40.758 MainServer::HandlePixmapLastModified() -
Couldn't find backend for:   : " "
2006-09-27 18:26:40.759 MythSocket(67c1b0:-1): writeStringList: Error,
socket went unconnected.
2006-09-27 18:26:40.761 MainServer::HandleGenPreviewPixmap()
                        Couldn't find backend for:
                          : " "
2006-09-27 18:26:41.271 RingBuf(file not found): Could not open file not found.
2006-09-27 18:26:41.272 Preview Error: Previewer could not open file:
'file not found'
2006-09-27 18:26:41.272 MainServer: Failed to make preview image.
2006-09-27 18:26:41.274 MainServer::HandleAnnounce FileTransfer
2006-09-27 18:26:41.275 adding: websrvr as a remote file transfer
2006-09-27 18:26:47.783 RingBuf(/mnt/store//file not found.png): Could
not open /mnt/store//file not found.png.
2006-09-27 18:26:47.791 MainServer::HandlePixmapLastModified() -
Couldn't find backend for:   : " "
2006-09-27 18:26:47.792 MainServer::HandleGenPreviewPixmap()
                        Couldn't find backend for:
                          : " "

besides the slowness... I don't see any issues / errors when I look at the
recorded listings.....

jack