Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

24 sec different between two same orders...

Status
Not open for further replies.

SFiend

Programmer
Jun 4, 2004
39
CZ
Hello,
could you tell me where is different or where is an mistake?

Code:
CREATE  TEMPORARY  TABLE Pomocna_tabulka 
SELECT Edar_Nakupy.Sleva AS Sleva, Edar_Nakupy.Duvod_slevy AS Duvod_slevy, ( Edar_Zbozi.Nakupni_cena * ( 1 - ( Edar_Nakupy.Sleva /100  )  )  ) AS Nakupni_cena_po_sleve, ( Edar_Zbozi.Nakupni_cena * Edar_Zbozi.Nakupni_kurz ) AS Nakupni_cena_v_mene, ( Edar_Zbozi.Nakupni_cena * ( 1 - ( Edar_Nakupy.Sleva /100  )  )  * Edar_Zbozi.Nakupni_kurz ) AS Nakupni_cena_v_mene_po_sleve, Edar_Zbozi.Prodejni_cena AS Konecna_cena, ( Edar_Zbozi.Prodejni_cena * ( 1 + ( Edar_Prodeje.Dph /100  )  )  ) AS Konecna_cena_s_dph, ( ( ( Edar_Zbozi.Prodejni_cena *100 ) / ( Edar_Zbozi.Nakupni_cena * Edar_Zbozi.Nakupni_kurz )  ) -100 ) AS Rabat, Edar_Zbozi. * , Edar_Skupiny.Nazev AS Nazev_skupiny, Edar_Podskupiny.Nazev AS Nazev_podskupiny, Edar_Polozky.Obrazek AS Obrazek
FROM Edar_Prevody, Edar_Nakupy, Edar_Prodeje, Edar_Zbozi, Edar_Skupiny, Edar_Podskupiny, Edar_Polozky
WHERE 7 
LIKE Edar_Zbozi.Id_prevodu AND Edar_Zbozi.Id_prevodu
LIKE Edar_Prevody.Id AND Edar_Zbozi.Id_prodeje
LIKE Edar_Prodeje.Id AND Edar_Zbozi.Id_nakupu
LIKE Edar_Nakupy.Id AND Edar_Prevody.Datum
BETWEEN 0  AND 1103817635  AND Edar_Podskupiny.Id_skupiny
LIKE Edar_Skupiny.Id AND Edar_Polozky.Id_podskupiny
LIKE Edar_Podskupiny.Id AND Edar_Zbozi.Id_polozky
LIKE Edar_Polozky.Id
ORDER BY Nazev_polozky ASC

and

Code:
SELECT Edar_Nakupy.Sleva AS Sleva, Edar_Nakupy.Duvod_slevy AS Duvod_slevy, ( Edar_Zbozi.Nakupni_cena * ( 1 - ( Edar_Nakupy.Sleva /100  )  )  ) AS Nakupni_cena_po_sleve, ( Edar_Zbozi.Nakupni_cena * Edar_Zbozi.Nakupni_kurz ) AS Nakupni_cena_v_mene, ( Edar_Zbozi.Nakupni_cena * ( 1 - ( Edar_Nakupy.Sleva /100  )  )  * Edar_Zbozi.Nakupni_kurz ) AS Nakupni_cena_v_mene_po_sleve, Edar_Zbozi.Prodejni_cena AS Konecna_cena, ( Edar_Zbozi.Prodejni_cena * ( 1 + ( Edar_Prodeje.Dph /100  )  )  ) AS Konecna_cena_s_dph, ( ( ( Edar_Zbozi.Prodejni_cena *100 ) / ( Edar_Zbozi.Nakupni_cena * Edar_Zbozi.Nakupni_kurz )  ) -100 ) AS Rabat, Edar_Zbozi. * , Edar_Skupiny.Nazev AS Nazev_skupiny, Edar_Podskupiny.Nazev AS Nazev_podskupiny, Edar_Polozky.Obrazek AS Obrazek
FROM Edar_Prevody, Edar_Nakupy, Edar_Prodeje, Edar_Zbozi, Edar_Skupiny, Edar_Podskupiny, Edar_Polozky
WHERE 7 
LIKE Edar_Zbozi.Id_prevodu AND Edar_Zbozi.Id_prevodu
LIKE Edar_Prevody.Id AND Edar_Zbozi.Id_prodeje
LIKE Edar_Prodeje.Id AND Edar_Zbozi.Id_nakupu
LIKE Edar_Nakupy.Id AND Edar_Prevody.Datum
BETWEEN 0  AND 1103817635  AND Edar_Podskupiny.Id_skupiny
LIKE Edar_Skupiny.Id AND Edar_Polozky.Id_podskupiny
LIKE Edar_Podskupiny.Id AND Edar_Zbozi.Id_polozky
LIKE Edar_Polozky.Id
ORDER  BY Nazev_polozky ASC

there is 23 seconds different. The first order only make temporary table.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top