[mythtv-users] Web interface scalability issue: Video Gallery

[Peter Bennett]

On 9/6/23 12:54, Jan Ceuleers wrote:
> On 03/09/2023 23:08, Peter Bennett wrote:
>> Thanks for testing this. I have about 1500 videos (on hard drive) and 
>> it takes between 1 and 2 seconds. With 5500 videos I would expect no 
>> more than 7 seconds.
>
> I just timed it again: it took 50 seconds.
>
>> I can investigate using a lazy load for videos. That may conflict 
>> with the directory listing scheme I have, where directories are 
>> listed and you can drill down.
>>
>> Do you use directories?
>
> I do use directories, yes. Lots of them:
>
>   * The top level is alphabetic in groups (0-9, A-B, C-D, E-F, G-H,
>     I-J, K-L, M, N-O-P-Q, R-S, T, U-V-W-X-Y-Z). So 12 directories at
>     the top level.
>   * The above directories contain movies, but also subdirectories (for
>     TV box sets).
>   * The TV box set directories can contain subdirectories for each
>     season. Single-season series don't have these subdirectories.
>
>> When it takes a long time, how many rows are reported (at the top 
>> level each direcory is a row)?
> Not sure what you're asking. Is there an incantation I should run to 
> produce the answer?
>>
>> Does clicking on a directory to see its contents also take a long time?
> No, that is instant.
>>
>> Does clicking back on Videos at the top after looking at a 
>> subdirectory also take a long time?
>
> No.
>
> Many thanks, Jan
>
>
Please try this, to see if the slowdown is on the backend:
curl "http://localhost:6544/Video/GetVideoList?Sort=FileName" >/dev/null

On my laptop it reports time spent 0:00:01 with over 7000 videos in my 
database.

If you are running your browser on a different computer from the 
backend, then try from that computer:
curl "http://backend:6544/Video/GetVideoList?Sort=FileName" >/dev/null

Look at the Time Spent. This will tell if it is a slowdown in the network.

Peter

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230906/515e4fe9/attachment.htm>