Shared Tag File Size, 2nd try

Please check the FAQ (https://www.xyplorer.com/faq.php) before posting a question...
Post Reply
zmachine01
Posts: 19
Joined: 16 Mar 2018 17:20

Shared Tag File Size, 2nd try

Post by zmachine01 » 24 Apr 2019 15:55

Well I asked this question a while back and there was no response so I'm trying again because I would really like to know this :

"Ok so now that we're running XY with the the auto-refreshing shared tag database, and thank you - it works wonderfully, is there any potential that the shared tag database file will become so big and cumbersome that it will start to affect XY's performance? I mean, what are the limitations? What if I wanted all my files to have the entire text of Ulysses forwards and backwards attached to them in the comment field?"

Thank you

RalphM
Posts: 1255
Joined: 27 Jan 2005 23:38
Location: Cairns, Australia

Re: Shared Tag File Size, 2nd try

Post by RalphM » 25 Apr 2019 07:38

As I'm not using tagging at all I might be the wrong guy to give you an answer and therefore leave the technical details to others that use it as well but as a general rule I would assume that you could run into limitations along the line with your given example, i.e. total size of the tag database, loading that file with every XY start, refreshing it with every change etc. but I assume the real performance issues might creep up if you start adding extra columns with these contents to your file list in order to filter them and such.
Maybe you could test this with your particular setup and a few thousand test files to see where this might lead performance wise.
Ralph :-)
(OS: W10 1809 Home x64 - XY: Current beta)

zmachine01
Posts: 19
Joined: 16 Mar 2018 17:20

Re: Shared Tag File Size, 2nd try

Post by zmachine01 » 26 Apr 2019 14:17

Ahh... Yes! there's someone alive out there! Thank you, RalphM. Testing it out is a good idea. Up until now I have just been very conservative with the comment tags that I add to my files... and during the writing of this sentence I just thought of my next question to post. But anyway I will try that.
I'm still a bit bewildered by the lack of response to this post. Was it just such a silly question or... I mean jeesh I hope I didn't make anyone's monocle pop out :eh:

highend
Posts: 8257
Joined: 06 Feb 2011 00:33

Re: Shared Tag File Size, 2nd try

Post by highend » 26 Apr 2019 14:20

The current file size limit is a bit above 100 MB.
One of my scripts helped you out? Please donate via Paypal or highend (at) web (dot) de

admin
Site Admin
Posts: 47485
Joined: 22 May 2004 16:48
Location: Cologne, Win 8.1, Win 10
Contact:

Re: Shared Tag File Size, 2nd try

Post by admin » 08 May 2019 20:10

Sorry, that I did not see/reply to the original question. So, yes, when that database is very fat, it will affect performance, but not extremely. Startup time willl suffer the most. Then a lot of RAM will be eaten and that will slow down things as well. The listing of folders will be slower, but notably only with very large folders. Still I would not recommend to attach Ulysses forwards AND backwards.

Note that XY also supports local databases (within the folder of the tagged items). Using this approach you won't have global search for tags, but you can totally forget about any performance issues.

Post Reply