cancel
Showing results for 
Search instead for 
Did you mean: 

why we are using flexibleSearchQuery instead of sql query finally flexiblesearch query translate in to sql query and execute sql query only

Former Member
0 Kudos

why we are using flexibleSearchQuery instead of sql query finally flexiblesearch query translate in to sql query and execute sql query only

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Because with FlexibleSearch you are talking to the Hybris persistence layer and you do not need to care (actually you must not care) what's below this. Eventually there is MongoDB below or another DB behind the persistence, you don't care, you can just use FlexibleQuery and all is good.

Answers (2)

Answers (2)

Former Member
0 Kudos

Apparently switching DBs on the backened is not always working. We have our dev team insisting on either default HSQLDB or SQLSVR. And I am trying to use ORACLE DB for performance. I have having few issues like nvarchar is being saved a blob. Anybody out there with pros and cons and any advise.

Aparna

christoph_meyer
Active Participant
0 Kudos

Flexible Search abstracts your tables to hybris data types/attributes. Additionally it enables features like search restrictions that are added to every search query for you.