0

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
marc_s
  • 704,970
  • 168
  • 1,303
  • 1,425
Yatin Mistry
  • 1,236
  • 2
  • 13
  • 33

0 Answers0