Jbg. Moram da zavrsim strukturu baze i samu bazu, da bih nastavio program, tri dana sam crtao i dijagrame i razmisljao sta mi je najbolje ali mislim da sam ovako dosta smanjio upit i JOINOVANJE evo sad izgleda ovako:
I generalno brzo radi 78ms. mislim da je to ok
Code:
SELECT SQL_CALC_FOUND_ROWS eqdb_device.Device_ID, eqdb_device.Status_ID, eqdb_device.Inventory, eqdb_device.Product, eqdb_device.Model, eqdb_device.EQ_ID, eqdb_device.Project, eqdb_device.Previous_Location, eqdb_device.Current_Location, eqdb_device.Current_Responsible, eqdb_device.Current_Assignment_Comment, eqdb_device.Next_Expected_Location, eqdb_device.Next_Assigned_Responsible, eqdb_device.Next_Assignment_Comment, eqdb_device.Date_Of_Expected_Arrival, eqdb_device.Transfer, eqdb_device.Date_Of_Lastchange, eqdb_department.Department_Name
FROM
eqdb_device
INNER JOIN eqdb_owner ON (eqdb_device.Owner_ID = eqdb_owner.Owner_ID)
INNER JOIN eqdb_customer ON (eqdb_device.Customer_ID = eqdb_customer.Customer_ID)
INNER JOIN eqdb_department ON (eqdb_device.Department_ID = eqdb_department.Department_ID)
WHERE (eqdb_device.Status_ID LIKE '%a%' OR eqdb_device.Inventory LIKE '%a%' OR eqdb_device.Product LIKE '%a%' OR eqdb_device.Model LIKE '%a%' OR eqdb_device.EQ_ID LIKE '%a%' OR eqdb_device.Project LIKE '%a%' OR eqdb_device.Previous_Location LIKE '%a%' OR eqdb_device.Current_Location LIKE '%a%' OR eqdb_device.Current_Responsible LIKE '%a%' OR eqdb_device.Current_Assignment_Comment LIKE '%a%' OR eqdb_device.Next_Expected_Location LIKE '%a%' OR eqdb_device.Next_Assigned_Responsible LIKE '%a%' OR eqdb_device.Next_Assignment_Comment LIKE '%a%' OR eqdb_device.Date_Of_Expected_Arrival LIKE '%-a %' OR eqdb_device.Transfer LIKE '%a%' OR eqdb_device.Date_Of_Lastchange LIKE '%-a %' OR eqdb_department.Department_Name LIKE '%a%' ) AND eqdb_device.Department_ID IN(1,2) LIMIT 10
E sad mozda ovaj upit moze jos bolje da se optimizuje, da na neki nacin izbegnem ovolike LIKE-ove. Ali sam stavio da su mi sve tabele innoDB tako da ne znam drugaciji nacin da pretrazim sva polja u tabeli za zadati kriterijum pretrage.
djLapac