? That would as its a database query and that side of solr is fast anyway.
The slow bit is indexing the documents and that isn’t in your query.
I think Solr is definately the way to go as also it fits Nextclouds federated mode.
A single line can use the local shard to make a distributed search across many installs in a simple command line.
The only dev work by next cloud would be an infrastructure to provide a secure tunnel to each instance.
Also another problem is access and also that is also part of the framework as current efforts with fulltext return results on the complete index. The problem being that it also shows results on the full index without regards to any security acl, but I could be wrong about that being a noob.
The grind has been done by Solr & Apache and its relatively simple to employ, create indexes and trawling is always going to be resource intensive I why I am slightly bemused in an event driven file system, it would seem a asynchronous trawling method is being used whilst file notification is available.
In fact really it must be event notification driven so that Acl and metadata can be pushed at the same time.
I am rusty as hell and don’t know for definate but with mysql you would have to provide the whole security and access system development whilst with solr the framework is off the self.
Its a good discussion though and one I am interested in, I could be completely wrong and don’t mind being told so.
I would be more worried about the current security model as it is a full text index and theoretically it can recreate all the documents and isn’t encrypted at the moment.
Also access in comparison to how the database is locked down it is relatively wide open which could be considered a huge security flaw.
I used to do a bit with a product called Worlddox for legal practises, wow thinking about it its almost 20 years ago now.
The MySQL full text search is not all that different from the MsSQL full text of that time, without doing any research.
Nextant just perked my interest and got me reading about Solr and wow expletive, its ace and probably exactly what Nextcloud needs with vastly less development need than any other solution I can think of apart from elastic.
Solr is sexy indexing stuff indeed and they already have the solutions for ACL & distributed search, which quite frankly are well beyond my capability to create, but I will gladly use.
Great piece of opensource heard about it but didn’t realise how good until a bit of reading of late.
The federated mode of nextcloud is like secure p2p storage and solr already could provide secure p2p indexing via acl control.
Its either elastic or solr and I haven’t enough knowledge to make difference between the two.
Because of previous experience my initial worries where about security and access, also you can not encrypt index fragments as it scatters the byte order and is no longer an index, but all those questions seem to be answered, but I am sure there is someone more knowledgeable who could make a better judgement call.