02-22-2020, 03:15 PM
I appreciate your support, but not solve, because my server not powerful and my database not have a enough performance for all user search no index data ..
and in this case, if a "generic" search, system will found a lot of registry and data senseless for the original research
For example, i have a custom filed called "CPF", as only sense as search data in this field, and another same pattern in others fields, not is senseless ( for this kind of search )
and see another two problems, many tables has more 100.000 registries, and "field modification time", is used in many filters ( in commercial process ) ...if I change all, this filters will be listing my all database ....
1) I can do that, with a script in batch, for example, without changed a "modification time" or include audit table ?
2) Special tags, or translation tag, could be use a "global variable" or business map to translate a hard code tag into a soft tag?
and in this case, if a "generic" search, system will found a lot of registry and data senseless for the original research
For example, i have a custom filed called "CPF", as only sense as search data in this field, and another same pattern in others fields, not is senseless ( for this kind of search )
and see another two problems, many tables has more 100.000 registries, and "field modification time", is used in many filters ( in commercial process ) ...if I change all, this filters will be listing my all database ....
1) I can do that, with a script in batch, for example, without changed a "modification time" or include audit table ?
2) Special tags, or translation tag, could be use a "global variable" or business map to translate a hard code tag into a soft tag?
Ranieri
eCRM Web
eCRM Web