Before adding stored procedure queries takes 13-15 sec.
After adding stored procedure it takes 24-25 sec.
I have also added indexes for columns.
Why it is not working as expected?
CREATE PROCEDURE GetCompanyFromSupplierId( IN productId VARCHAR( 11 ) ,
IN supplierId INT( 11 ) )
BEGIN
SELECT
DISTINCT company_csv_data.CompanyID AS CompanyID,
company.ContactPerson,
company.CompanyWebsite AS destinationurl
FROM (`company_csv_data`)
INNER JOIN `company` ON `company_csv_data`.`CompanyID` = `company`.`CompanyID`
WHERE company_csv_data.company_csv_id = productId
AND company_csv_data.supplier_name = supplierId
LIMIT 1 ;
END