You can have 40+ million documents and half a terabyte index size and still not need spark or solr cloud or sharding and get sub second results. Don’t over think it until it becomes a real issue
> On Jan 29, 2023, at 1:53 PM, marc nicole <mk1853...@gmail.com> wrote: > > Much appreciated. > >> Le dim. 29 janv. 2023 à 17:47, Andy Lester <a...@petdance.com> a écrit : >> >> >> >>>> On Jan 29, 2023, at 4:45 AM, marc nicole <mk1853...@gmail.com> wrote: >>> >>> Let's say you're right about the 200 rows being too few. From which row >>> count I can see the difference reflected in the results as it should >> (Solr >>> faster)? >> >> It depends on how much data is in each record, but I'd think 10,000 - >> 100,000 is a starting point. >> >> Andy