All geek questions in one place

Create effective search capabilities using SQL Server (and / or coldfusion)

I am trying to imagine how to create a search for the application we are creating. I would like to suggest how to approach search through large data arrays.

For example, this particular search will consist of a minimum record table of 750 thousand pages, determining product size, material size, creation date, etc.

Does anyone know of “plugins” for Coldfusion for this? I assume that the Google search engine is as a single entry, where the client can enter the part number, or size, etc., and get access to any or all relevant results.

Currently, if I run the comparison request "LIKE", it seems like it takes a lot of time (normally a few seconds, but still) and it is too long. Sometimes the user sits there and waits up to 10 seconds for requests and page loads.

Or are there any SQL formulas to help with this? I want to use a proven data lookup method, not just a simple SQL or a comparison operation.

So this is a question with several approaches, should I attack this at the SQL level (what it ultimately looks like) or is there a plugin / module for ColdFusion that I can capture, which will give me a quick, advanced search opportunity.

+3
source share
5 answers

db Verity ( Solr, if CF9).

, , , , , . , Verity . , - , , .

Verity, PDF , Word Docs .., , . , , , , .

+3

- , , ( LIKE), ( , ).

, (1 ) . , 3- , "", .

( ) - , / .

, "LIKE", ( ), SKU .. .

, , - compund (SKU, ..) , ( ) ( , , /).

, , , .

, , , , "", " " . , "" / "" . , en/de-coding . , .

+3

SQL. , .

Full Text . , . ; , SQL Server .

-, , , . . , ( Split), , :

"Word1 *" AND "Word2 *" AND "Word3 *"

; , .

, , ContainsTable :

    SELECT *
    from containstable(Bugs, *, '"Word1*" AND "Word2*" AND "Word3*"')

:

  • - ,
  • - (1 - 1000 , ).

, , .

+2

, Google. , - ( "SKU" ), , , - . , Google , , . . SQl, , coldfusion. .

coldfusion 6 ! , , , google , , , , , ( Google, )

+1

SQL Server - , - , . , , , , , SELECT * FROM TABLEX WHERE last_name LIKE '% FR%'

But it can use an index if you do it like this: SELECT * FROM TABLEX WHERE last_name LIKE 'FR%'. The key point here is that many of the first characters will not be wild.

Here is a link to the site with some general tips. https://web.archive.org/web/1/http://blogs.techrepublic%2ecom%2ecom/datacenter/?p=173

-1
source

Source: https://habr.com/ru/post/1721881/

More articles:


All Articles