Global Name Search

This is an implementation using globals for user name search.

You can use this algorithm to favor the search of individuals

This application contains a Person table populated with many users, where the search takes place through the users Name, FirstName, MiddleName and LastName.

Prerequisites

Make sure you have git and Docker desktop installed.

Installation

Clone/git pull the repo into any local directory

$ git clone https://github.com/Davi-Massaru/global-name-search.git

Open the terminal in this directory and run:

$ docker-compose build
$ docker-compose up -d

Get Started

Use this feature in a scenario where there is a many volume of data and you need to return a limited length of records, for example, when selecting selects or datacombos.

This technique allows the data to be returned faster and also with a much smaller amount of global accesses than a “SELECT TOP”, for example.

Open the Manegement Portal and try execute the selects:

    SELECT TOP 500 ID, Name FROM dc_data.Person WHERE Name LIKE '%jose%'

Result:

Compare to

	SELECT ID, Name FROM dc_data.Person WHERE ID %INLIST dc.GetListIdsByName('jose',,,500)

Dream team