Perhaps a simple feature to permit high speed searches in RadSearch is to allow custom SQL Select strings in lieu of direct connect to a SQL Datasource (unless there is a way to accomplish the following in a SQL Datasource)
I have FreeText and text optimization configured/added in SQL Server. This provides a tremendous speed boost for searching strings. Therefore, somehow in the RadSearch box allow searches such as:
SELECT * FROM myTable WHERE contains(myTextIndexedColumn,'this is fast')
SELECT * FROM myTable WHERE FreeText(myTextIndexedColumn,'this is so much faster!')
Hello Henry,
The DataSourceSelect seems like the perfect event to tweak the SqlDataSource's Select command and use the FreeText():
Regards,
Peter Milchev
Progress Telerik
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
oops, that should has said:
SELECT theColumnIWant FROM myTable WHERE contains(myTextIndexedColumn,'this is fast')
SELECT theColumnIWant FROM myTable WHERE FreeText(myTextIndexedColumn,'this is so much faster!')