[db-wg] fulltextsearch question

Hi Hank,

> On 17 Jun 2021, at 23:46, Edward Shryane via db-wg <db-wg at ripe.net> wrote:
> 
> Hi Hank,
> 
> I spoke too soon, Whois still restricts the maximum results to 100. I'll investigate how to retrieve more results and get back to you.
> 
> Regards
> Ed
> 

Apologies for my delay in replying, I wanted to be sure, but there is currently a hard limit of 100 results in the backend API.  We introduced this limit because the full text search engine is much more resource intensive than the database, and it was possible to crash Whois by querying for too many objects. We set a relatively low limit as we found that most users only requested the first page of results.

The full text search API is currently only used by the DB web application, and we haven't opened it yet for general use. When we improve the query page in the upcoming months, we will also review the backend API, open it for general use and increase the query limit.

Regards
Ed Shryane
RIPE NCC