#35 Covers not shown in List after load (MySQL only)

[Matthias Ihmig]

Forum entry:
http://sourceforge.net/forum/forum.php?thread_id=1729579&forum_id=285354

This bug only occurs when using MySQL.

When I close xmm (with "Load last DB set") and open it again, it loads the previous mysql db correctly, but it does not show the icons in the movie list at first. I have to click every item to make it show correctly.

I also need to do this when I have "Store covers locally" Enabled.

The covers are also not shown, when I add new movies via "Import from Text" with "Get IMDb Info"
- the import&query is done correctly, but I have to close and re-open the mysql-database before the Covers
are displayed.

Matthias

[Bro]

Logged In: YES
user_id=840074
Originator: NO

I've updated the CVS. When using MySQL and wihtout enabling the "store covers locally" the cover will only show in the list on entries that have been selected.
When enabling "store covers locally" the covers in the list should show on all the entries with the cover saved on disk.

Bro

[Matthias Ihmig]

Logged In: YES
user_id=921651
Originator: YES

Ah, I see. I suppose the covers are not loaded all at once from mysql db because of performance issues?

If so, we can close this bug, as it is in fact a feature. (we should then maybe document this at some point somewhere)

It now works when using "Store covers locally".

Thanks,

Matthias

[Matthias Ihmig]

Logged In: YES
user_id=921651
Originator: YES

I just played around a little with loading covers directly from mysql and it seemed quite fast.
What was the reason for not loading all covers at once when using mysql? just performance, or also other reasons?

Matthias

[Bro]

Logged In: YES
user_id=840074
Originator: NO

It's only because of performance.
When connecting to a server on localhost it will of course have no any significant effect.
On the other hand, when connected from a remote location it may take more time than usual to retrieve the data, especially the cover data.
If the covers were all retrieved when loading the database it would be a pain to have to wait for the data being retrieved every time.

Bro

[Matthias Ihmig]

Logged In: YES
user_id=921651
Originator: YES

Ah, ok. Maybe later, I'll introduce a config switch to configure this behaviour. With all this increasing bandwidth, the performance loss might get smaller. and if it's only used in a home network, this shouldn't be a problem as well.

I'll close this thread.

Matthias

[Bro]

Logged In: YES
user_id=840074
Originator: NO

Actually I'm not sure a high bandwidth line will do.
When I've tested this it made a clear difference, and that was on what you can consider a fast line.
But as stated before, in a home network it shouldn't make a difference.
When the database grows bigger it will take time to download all the covers from the list, but that should be easy to test ;-)

Bro