Completed
Last Updated: 15 Feb 2021 11:43 by ADMIN
n/a
Created on: 08 Feb 2021 22:45
Category: SearchBox
Type: Feature Request
0
RadSearch is slow in massive Databases

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!') 

2 comments
ADMIN
Peter Milchev
Posted on: 15 Feb 2021 11:43

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/.

n/a
Posted on: 08 Feb 2021 22:46

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!')