nuBuilder Forum

I have a table with a large number of rows and the delay building the unfiltered view in the browse form is significant.
I have attempted to solve this by prefiltering the view before opening the browse form.

I have added a text field next to the browse button, entering a filter string there before pressing the button.
The "Default Filter for Browse" field of the button is set to the name of the text field. When I press the browse button, the browse form opens as expected, and
the records are filtered correctly.

However, if I now want to change the filter string by typing into the browse form search field, I get a filtered view of the filtered table. What I would like is for
the new search to run on the whole table, not the prefiltered view.

Any suggestions about how to do this correctly?

miketee,

Are you joining more than 1 table?

Do you have indexes on any fields?


Steven

Steven,

It's a single table, but has 500k records. I have primary key and 3 other fields indexed, individually.

miketee,

You say 'view', do you mean a mySQL 'View' or a single Table?

Have you hard coded an 'order by' in the sql for that browse?

How old is the server you are using?

Steven

Steven,

It's a single table, no ORDER BY, brand new server installation.

If we leave the speed issue aside for now, what is the correct way to give the user a pre-filtered browse screen, but then allow the user to change the browse filter so that the pre-filter string is overridden by the browse screen search string? ie the user is in full control of the filtering.

miketee,
http://wiki.nubuilder.net/nubuilderv3/i ... for_Browse

Steven