SQL baze podataka - Sponzor: Baze-Podataka.net MySQL, MSSQL, Oracle, Access, ODBC. Ako imate problem brže i preciznije ćete dobiti odgovor ako priložite strukturu tabela ili skript koji kreira tabele i puni ih test podacima umesto što to problem opisujete samo rečima. Sponzor: Baze-Podataka.net - Blog o bazama podataka |
|
Alati teme | Način prikaza |
31. 07. 2007. | #1 |
Ivan Dilber
Sir Write-a-Lot
|
spor query
baza je mysql, a query je:
Kôd:
$sql = "( SELECT ID, Title, SUBSTRING(Body,1,180) AS tekst, db_num, MATCH (Title,Body) AGAINST ('$q') AS relevance FROM articles WHERE Title LIKE '%$subdomain%' AND MATCH (Title,Body) AGAINST ('$q') LIMIT ".NUM_RESULTS_ARTICLES." ) UNION ( SELECT ID, Title, SUBSTRING(Body,1,180) AS tekst, db_num, MATCH (Title,Body) AGAINST ('$q') AS relevance FROM articles2 WHERE Title LIKE '%$subdomain%' AND MATCH (Title,Body) AGAINST ('$q') LIMIT ".NUM_RESULTS_ARTICLES." ) UNION ( SELECT ID, Title, SUBSTRING(Body,1,180) AS tekst, db_num, MATCH (Title,Body) AGAINST ('$q') AS relevance FROM articles3 WHERE Title LIKE '%$subdomain%' AND MATCH (Title,Body) AGAINST ('$q') LIMIT ".NUM_RESULTS_ARTICLES." ) ORDER BY relevance DESC LIMIT ".NUM_RESULTS_ARTICLES;" E sad, kad se radi samo fulltext search to radi jako lepo i brzo, ali kad sam dodao ovaj dodatni uslov za Title server je poceo da se vuce stravicno. To mi je extra cudno jer EXPLAIN kaze da se u oba slucaja koristi isti FULLTEXT index, a LIKE ionako ne moze da koristi index, znaci samo treba da isfiltrira dodatno Title polje. Medjutim, nesto se tu mysql-u ne doapada... Da li postoji neki bolji nacin da se ovo odradi?
__________________
Leadership is the art of getting people to want to do what you know must be done. |
31. 07. 2007. | #2 | |
Domagoj Horvat
Expert
|
Citat:
MATCH (Title,Body) AGAINST ('$q') AND Title LIKE '%$subdomain%'
__________________
postoje ludosti bez kojih je nemoguce ljudsko dostojanstvo |
|
|
|
Slične teme | ||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Id, kategorija - jedan query | Ivan | SQL baze podataka - Sponzor: Baze-Podataka.net | 4 | 13. 11. 2007. 03:09 |
Pisanje mysql query | bluesman | SQL baze podataka - Sponzor: Baze-Podataka.net | 30 | 05. 06. 2007. 12:53 |
sql query | bluesman | SQL baze podataka - Sponzor: Baze-Podataka.net | 19 | 18. 04. 2007. 07:47 |
mysql, php i unbuffered query | ivanhoe | SQL baze podataka - Sponzor: Baze-Podataka.net | 1 | 21. 07. 2006. 04:50 |