FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour [HM] New post at Harbour Magazine
Posts: 564
Joined: Thu Oct 13, 2005 09:23 AM
[HM] New post at Harbour Magazine
Posted: Wed Jan 31, 2018 05:41 PM

Nueva entrada en Harbour Magazine, sobre como usar opciones de filtrado en Harbour.

https://medium.com/harbour-magazine/pon ... 6dbb92f275

New post at Harbour Magazine, about how th use filtering options with Harbour.

https://medium.com/harbour-magazine/put ... 240aea74e0

Regards,
José Luis

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: [HM] New post at Harbour Magazine
Posted: Thu Feb 01, 2018 06:52 AM

Hello Luis,
thank you for your post and work.
Maybe you can compare filters to temporary index too.
Best regards,
Otto

Posts: 564
Joined: Thu Oct 13, 2005 09:23 AM
Re: [HM] New post at Harbour Magazine
Posted: Fri Feb 02, 2018 07:12 AM

Hello Otto,
I think that filters are powerfull than temporary indexes. With filters you can change the index order and the filter remains, and this behavour is very hard to obtain with temporary indexes.

Regards,
José Luis

Posts: 6983
Joined: Fri Oct 07, 2005 07:07 PM
Re: [HM] New post at Harbour Magazine
Posted: Fri Feb 02, 2018 07:29 AM

Hello Luis,
For me filters where always dangerous because you never new if you have set somewhere a filter and then you reused the workspace and got wrong results.
You write in your article that you have a warning build in – which is very good and important.
As creating a temporary dbf-file which the “filtered” result is very fast these days (SSD disks) I use this technique much.
Best regards,
Otto

Posts: 4840
Joined: Fri Nov 18, 2005 04:52 PM
Re: [HM] New post at Harbour Magazine
Posted: Sat Feb 03, 2018 03:56 PM
Otto,

For me filters where always dangerous because you never new if you have set somewhere a filter and then you reused the workspace and got wrong results
.

I'm not sure if you meant reusing a database object or reusing a workspace. With database objects you don't ever have to deal with workspaces. You can always open another copy of the same database object--then you don't have those problems.

If you prefer to use the same object, then you should always save and restore it's state (recno(), index, filter, etc.) in the particular routine (function or method) then you won't have those problems either. Save it at the start of the routine and restore it at the end.

However, I don't use filters either--they are just too slow and require extra programming (like the above).

James
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: [HM] New post at Harbour Magazine
Posted: Mon Feb 05, 2018 07:56 AM

I think that filters are powerfull than temporary indexes. With filters you can change the index order and the filter remains, and this behavour is very hard to obtain with temporary indexes.

I too hold the same opinion. But we should know how the RDD optimizes performance with filters.


they are just too slow

This is a very very old story.
Yes, they were slow till Foxpro came up with Rushmore technology long time back. Later comix and six implemented same technology. Present DBFCDX too implements the same. They can be quite fast but we need to understand how the RDD optimizes filters.
Regards



G. N. Rao.

Hyderabad, India
Posts: 9020
Joined: Thu Oct 06, 2005 08:17 PM
Re: [HM] New post at Harbour Magazine
Posted: Mon Feb 05, 2018 06:25 PM
nageswaragunupudi wrote:

they are just too slow

This is a very very old story.
Yes, they were slow till Foxpro came up with Rushmore technology long time back. Later comix and six implemented same technology. Present DBFCDX too implements the same. They can be quite fast but we need to understand how the RDD optimizes filters.


Please can you show a test demonstrating what you stated? I'm sincerely curious to see a SET FILTER that is not unacceptably slow.

EMG

Continue the discussion