Novem-IT, novem-it.dk presentation of enhancement to extended datalist module allowing huge datalists in excess of 100000 http://youtu.be/gzvTibbThpo?a
We do not know where the limit is .. The enhancement of the search could be a candidate for improving the search interface.
The magic is really an implementation of a count-query, that is the ability to perform an unlimited search returning no rows/results, but the number of matching nodes found (not returned nodes). Since we then know the total size of the query, the real data query need only do skip and fetch a single page (~50 nodes). SOLR4 performs super doing this, returning page results for given page in 0,4 seconds for webscript response with datalist size of 140000!