I have two tables, WORD_FILTER and WORDS:

WORD_FILTER: 87 records

WORDS: 345,000 records

The WORD_FILTER database has the following fields:

id_word_filter

max_length

max_syllables

filter_prefix

filter_suffix

found_count

The WORDS database has the following fields:

id_words

fk_id_word_filter

word

length

syllable_count

I need to filter the "WORDS" portal by defining the following fields with something like this:

max_length = 12

max_syllables = 2

filter_prefix = re

filter_suffix = ing

So in this example I need the portal results to show me all words that are:

less than 13 characters in length

contain less than 3 syllables

begins with the letters "re"

and ends in the letters "ing"

I can get all of this to work with port filtering but there are several problems with port filtering that I cannot overcome.

1.) It's painfully slow.

2.) I cannot get a correct count of the found sent.

3.) I cannot run a looping script to process the found set as desired.

Does anyone have any suggestions on how this can be done.

Thanks.

Points 2 and 3 are solvable - but with approximately 4,000 related records, portal filtering is going to be slow. I'd suggest you move as much of the filtering as possible to the relationship, and leave portal filtering only for the prefix and suffix.

Alternately, reconsider use of a portal. A list and find operation will be way faster and directly return the found count.