This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
June 03, 2008 3:49pm
Subscribe [11]#16 / Jul 06, 2010 1:41am
Correct me if I’m wrong, but doesn’t this code pull every single entry, and then just display the relevant ones? WOuldn’t add a lot of overhead with thousands of records? Surely a query that only pulls the required entries each time would be a lot more efficient?
Really wish you could just do something like search:title=“A*” in the channel entries tag!
#17 / Jul 06, 2010 5:55am
Yes it does pull every entry and yes, search:title=“A*” would be cool.
Though I guess it’s not too big an overhead to have an initial letter custom field, which would have the side benefit of helping to handle cases such as terms beginning with ‘The’—eg: ‘The Royal Society’; initial letter: ‘R’.