Page 1 of 1

Search function in browse form

PostPosted: Fri Oct 25, 2019 9:18 pm
by mariri
Hi guys !

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 :)