CMFILTER, CMCLRFILTER

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
Pablo César
Posts: 4058
Joined: Wed Sep 08, 2010 1:18 pm
Location: Curitiba - Brasil
Has thanked: 100 times
Been thanked: 177 times

CMFILTER, CMCLRFILTER

Post by Pablo César » Thu Feb 09, 2017 10:43 pm

I've always hated the SET FILTERs slowness.

I have always used different keyed indexes depending on the available option.
HMGing a better world
"Matter tells space how to curve, space tells matter how to move."
Albert Einstein

trmpluym
Posts: 193
Joined: Tue Jul 15, 2014 6:52 pm
Location: The Netherlands
Has thanked: 4 times
Been thanked: 11 times

Post by trmpluym » Thu Feb 09, 2017 11:18 pm

franco wrote:
Thu Feb 09, 2017 9:58 pm
Hello to all,
I have never found filters work on large tables. That is why I use temp indexes.
Franco, can you test cmFilter on a large table and give some feedback about the results ? But when you test it make shure there is a relevant index available so cmFilter can do its work.

Theo

franco
Posts: 200
Joined: Sat Nov 02, 2013 5:42 am
DBs Used: DBF
Been thanked: 6 times

Post by franco » Fri Feb 10, 2017 7:24 pm

Theo,
I use index (FOR) not (WHILE), so the relevant index has no effect. If the relevant index is set, then my filtered list is in the relevant index order.
The search goes throgh the whole file, but is still very fast.
Franco

trmpluym
Posts: 193
Joined: Tue Jul 15, 2014 6:52 pm
Location: The Netherlands
Has thanked: 4 times
Been thanked: 11 times

Post by trmpluym » Sat Feb 11, 2017 1:01 pm

Thanks for testing Franco !

EduardoLuis
Posts: 520
Joined: Tue Jun 04, 2013 6:33 pm
Location: Argentina
Been thanked: 28 times

Post by EduardoLuis » Tue Feb 14, 2017 1:49 pm

Hi Friends:

Some time ago, i modify a code post by LuisVazques, where he show how to speed a search on a big dbf file.-
For best speed on seach procedure i transfer dbf data to an array and with array data i fill a virtualgrid.-
All procedures of searching or sorting in virtualgrid are +10 times highspeed than doing over a dbf phisically.-
Instead seek search on an index taking a priority the first letter of the field, procedure implemented by LuisVazques search a portion of text on each cell, and if that portion is found add array element to the virtualgrid.-
I'm preparing a sample to show the result.-
I have not tested on arrays bigger than 100000 items, but 100000 items is a big number, and up to there works like a charm.
With regards.-
Eduardo

trmpluym
Posts: 193
Joined: Tue Jul 15, 2014 6:52 pm
Location: The Netherlands
Has thanked: 4 times
Been thanked: 11 times

Post by trmpluym » Tue Feb 14, 2017 9:32 pm

Eduardo,

i am very curious and looking forward to see your demo.

I am especially curious how you use this in an multi user environment (locking).

Theo

Post Reply