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 |
![]() |
#1 |
profesionalac
Professional
|
![]() Tabela orders ima 200 redova, a join daje 250 000 rezultata. Pa vi vidite...
Kôd:
select DISTINCT o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, s.orders_status_name, pd.products_description, ovh.comments from orders o, orders_status s, orders_vendors ov, orders_vendors_status_history ovh, products_description pd, products p where ov.vendors_id = '1' and o.orders_id = ov.orders_id and ov.orders_status = s.orders_status_id and s.language_id = '1' and ovh.orders_id = o.orders_id and p.products_id = pd.products_id and MATCH(o.customers_name) AGAINST ('test' IN BOOLEAN MODE) order by orders_id DESC
__________________
The knack of flying is learning how to throw yourself at the ground and miss. |
![]() |
![]() |
Alati teme | |
Način prikaza | |
|
|
![]() |
||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Benchmarking rezultati mysql, lucene i sphinx... | nixa | SQL baze podataka - Sponzor: Baze-Podataka.net | 1 | 30. 08. 2007. 08:35 |
cudni neki google oglasi | ivanhoe | Marketing i SEO | 5 | 28. 05. 2007. 15:32 |
Razliciti rezultati za pretrage u mnozini | cvele | Marketing i SEO | 0 | 18. 10. 2005. 02:17 |