Default limiting results & wildcard support

[Tom Lancaster]

Hello,

I've recently noticed that when performing searches that i imagine have a large number of results that generally the results stop from January 2020 onwards, e.g.:

https://crt.sh/?q=example.%25

This means that any new domains after January 2020 are not visible. For my use case i would find it more useful if the results were sorted by Logged At (desc). Is there a way to do this? Or could the default search be conceivably changed to sort results this way?

Cheers,

Tom

[Tom Lancaster]

To clarify, incase this is a temporal issue, here are the current results for this search:

[Rob Stradling]

Hi Tom.  This issue has been discussed before, most recently at https://crt.sh/forum?place=msg%2Fcrtsh%2Fhsv9m0837hw%2FuvRV0Lg5BgAJ.

The tl;dr is that postgres's Full Text Search just isn't geared towards sorting or paginating large result sets.  :-(