Anonymous, bureaucrat, administrator
7,528
edits
Changes
From All n One's bxp software Wixi
no edit summary
On large database tables ''like'' searching can cause massive speed overhead for no appreciable useful functionality. Like matching is what gives us fuzzy searching.
A quick example to explain. If you have an id field with for example 8 digits or more in it. You have 1000 records. You enter in 123456 as your search criteria, the database server will search for every combo of that Id, e.g. 123456XX, X123456X and XX123456. So that's 3 different combinations on 1000 = 3000 searches. Fuzzy is helpful when searching names, but not really necessary when searching Id fields. Instead you should consider making the search an "exact" search. This means that the Id number is found exactly or not at all.
Here are some record statistics from bxp
* Database: 1.2 million customer records
N.B. A precision match means that case sensitivity is also adhered to. i.e. "bxp software" is not the same as "business express" = Indexes = An index is a special feature of a database which has the ability to vastly increase the speed of searches at the cost of space. Imagine some data. {| class="wikitable"|-! first_name | last_name | primary interest | company_name | address | city|-| Emma | Lacey | Product 1 | Alan D Rosenburg Cpa Pc | 14 Taylor St | St. Stephens Ward|-| Evan | Zigomalas | Product 1 | Cap Gemini America | 5 Binney St | Abbey Ward|-| France | Andrade | Product 1 | Elliott, John W Esq | 8 Moor Place | East Southbourne and Tuckton W|-| Ulysses | Mcwalters | Product 1 | Mcmahan, Ben L | 505 Exeter Rd | Hawerby cum Beesby|-| Tyisha | Veness | Product 1 | Champagne Room | 5396 Forth Street | Greets Green and Lyng Ward|-| Eric | Rampy | Product 1 | Thompson, Michael C Esq | 9472 Lind St | Desborough|-| Marg | Grasmick | Product 1 | Wrangle Hill Auto Auct & Slvg | 7457 Cowl St #70 | Bargate Ward|-| Laquita | Hisaw | Product 1 | In Communications Inc | 20 Gloucester Pl #96 | Chirton Ward|-| Lura | Manzella | Product 1 | Bizerba Usa Inc | 929 Augustine St | Staple Hill Ward|}
If you need to enable a custom index, please contact your account manager to have the field indexed for you.
