# From SQL to Solr – A Smarter Search Experience

<table><thead><tr><th>Release Type</th><th>Effective Date</th><th width="495.484375">Impact</th></tr></thead><tbody><tr><td>Major functional upgrade</td><td>Beta launch from 15 to 22 May 2025</td><td><p></p><ul><li><strong>User Experience:</strong> Significantly improved with faster, more responsive search interactions (no page reloads, suggested results).</li><li><strong>Performance:</strong> Improved search speed and scalability, especially noticeable on large product catalogues.</li><li><strong>Developer Flexibility:</strong> Enables greater customisation and frontend innovation via API-driven architecture.</li><li><strong>No Downtime Expected:</strong> The transition is seamless and will not require users or merchants to make any changes.</li></ul></td></tr></tbody></table>

<figure><img src="/files/VumMYh9bkrjVm9rbpNtv" alt=""><figcaption></figcaption></figure>

***

**🔄 What Changed:**

***

* Replaced the legacy SQL-based search with a [Solr-powered](https://solr.apache.org/features.html) search engine.
* Introduced real-time suggested search terms to assist users as they type.
* Implemented Ajax-based search result loading, eliminating full page reloads.
* Aligned the search functionality with our ongoing headless architecture transition, enabling API-driven, decoupled frontend capabilities.
* Laid the groundwork for future enhancements like search filtering, personalisation, and AI-driven ranking.

***

**✅  Key Enhancements:**

***

**1. Suggested Search**

Users will receive real-time search suggestions as they type, dramatically improving the speed and relevance of product discovery.

**2. Ajax-Based Results (No Page Reloads)**

Search results are now fetched dynamically without a full page reload, offering a fast, seamless user experience—a core benefit of our headless transition.

***

**🧠  Why** [**Solr**](https://solr.apache.org/)**?**

***

Solr is a robust, enterprise-grade search engine that enhances:

* Performance & Scalability: Handles large product catalogs with ease
* Relevance & Speed: Delivers accurate, lightning-fast results
* Flexibility: Supports future enhancements like AI ranking, advanced filtering, and personalisation


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.storefront.co.za/storefront/roadmap/from-sql-to-solr-a-smarter-search-experience.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.