How the search browse function works ? When a user do some research by criteria in a browse form, this is very slow.
Maybe is it due to bad database design ?
There are two tables :
Person
person_id
person_last_name
person_first_name
Action
action_id
action_date
action_description
#person_id# (foreign key)
There are this following columns in a browse form : person_last_name, person_first_name, action_date, action_description. And when the user filters by person name, results are slowly display.
Thanks for ur help
