Jump to content

Cannot get portal filtering to work with global field


HALBURN
 Share

This topic is 4340 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 4340 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.