© Phil Wicklund and Jason Wilkerson 2016

Phil Wicklund and Jason Wilkerson, Professional Sitecore 8 Development, 10.1007/978-1-4842-2292-8_8

8. Search-Driven Solutions

Phil Wicklund and Jason Wilkerson2

(1)Minneapolis, Minnesota, USA

(2)Minnetrista, Minnesota, USA

Up until this point all of our code has been hitting the Sitecore database directly whenever we've needed Sitecore data. This, however, isn’t always the best practice. For one it can put a lot of CPU pressure on your SQL server. For another, it doesn’t perform well. Full-text search is a great example of where, if it were a SQL query, you would need to inspect every single row.

A better way is to index your data in such a way to enable it to be searched, accessed quickly and at scale. Fortunately, ...

Get Professional Sitecore 8 Development: A Complete Guide to Solutions and Best Practices now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.