Is the order of fields important for filtering data ?

Is the order of fields important for filtering data ?

Postby Marc Venken » Wed Oct 09, 2024 3:25 pm

I wonder if using multiple fields to perform a filter (used in a Xbrowse with the headers search gets) the order is important.

Let say that I want foling fields filtered :

Index is on Name : filter like Name...+Color++++Size (filter setting)

Name : Test
Color : Blue
size : Large

Second option is the field Color is before the name in the browse, the filter will be :

Color...+Name....+Size (filter setting)

In the first case, the filter's first field is a index field and I think that it will go direct to a position of the name
In the second case the corlor has no index and I think that ALL record will be processed and then the rest of the filter.

I hope my question make sence )))

Witch is best ?
Marc Venken
Using: FWH 23.04 with Harbour
User avatar
Marc Venken
 
Posts: 1447
Joined: Tue Jun 14, 2016 7:51 am
Location: Belgium

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Horizon and 42 guests