2010-03-25, 22:24
MrDVD Wrote:For me the serverside image cache works also without any speed problems. .
Yes... please do explain this
MrDVD Wrote:For me the serverside image cache works also without any speed problems. .
SELECT * FROM `episode` LIMIT 0 , 10000
Showing rows 0 - 9545 (9,546 total, Query took 0.2965 sec)
MrDVD Wrote:Hallo, my server is linux based and my xbmc clients also. (both on Ubuntu 9.10)
The image cache, mysql and all media are on the server.
Each clients run there own xbmc but the Thumbnails folder is on the server and only linked to the default folder on the clients.
The server itself run also an xbmc.
Total i run 3 clients and cant see any diff from the speed. (local / remote Thumbnails folder)
Now i cant wait for new funktions like "follow me" or something like this
MrDVD Wrote:Edit:The query you've presented here meassures the access times to the database not access times to the image cache.
A simple sql command inside mysql:
Code:SELECT * FROM `episode` LIMIT 0 , 10000
When i run the same command inside an SQLite Manager it takes ~ 3-4 sec.Code:Showing rows 0 - 9545 (9,546 total, Query took 0.2965 sec)
charrua Wrote:Here's the results I got:How did you set up the folder redirection for the central shared cache?
-Central Network Shared Cache: It does work, but in my trial it takes thrice the time of XBMC using a local cache to load the movie list screen. So (as expected) it works but it's noticeable slower, at least in my case.
?
bradvido88 Wrote:How did you set up the folder redirection for the central shared cache?First I copied the thumbnails folder inside userdata to the server, then I shared that path from the server, renamed the thumbnails folder inside userdata folder in the client machine to thumbnails.old (to avoid its deletion) and finally made a NTFS directory symbolic link pointing to the shared folder in my server with the command:
[b]mklink /D[/b] thumbnails [i]//SERVER_ADDRESS/shared_thumbnails_folder[/i]
charrua Wrote:Thanks for your replyNo, each client have his own xbmc install.
I understood that you were running XBMC from the server as RenZ0R suggested...
Quote:The image cache, mysql and all media are on the server.you were referring to a LINUX environment.
Each clients run there own xbmc but the Thumbnails folder is on the server and only linked to the default folder on the clients.
<videodatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
rtrimarchi Wrote:MrDVD,rtrimarchi, that is correct for the library database connection (also valid for linux environments), but MrDVD is trying to solve the thumbnail cache problem: XBMC clients connecting to a central MySQL database don't regenerate thumbnails for new media scraped by other XBMC clients storing info in the same database.
when you said:
you were referring to a LINUX environment.
In a WINDOWS environment, Where in XBMC do you create this LINK to the server thumbnails folder ON the SERVER
So far, as charrua said at the beginning, in XBMC you have ONLY to modify the ADVANCEDSETTINGS.XML like this:
Code:<videodatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
charrua Wrote:First I copied the thumbnails folder inside userdata to the server, then I shared that path from the server, renamed the thumbnails folder inside userdata folder in the client machine to thumbnails.old (to avoid its deletion) and finally made a NTFS directory symbolic link pointing to the shared folder in my server with the command:
If you try it, please let me know if in your case it is also noticeable slower than the local cache. Anyway is not a bad option until the new cache system is in place.Code:[b]mklink /D[/b] thumbnails [i]//SERVER_ADDRESS/shared_thumbnails_folder[/i]
rtrimarchi Wrote:Also.... if I understand correctly......the two solution (mysql + remote thumbnails) can be BOTH done simultaneously ... rightYes, you're right.
rtrimarchi Wrote:But instead of creating a symbolic link with mklink, isn't there an .xml file in XBMC where we can modify this local path with the remote oneNot that I know of...