when I checked the records again, its actually close to 200,000 and thats in each table
when I run that query it takes around 4mins then it shows me 1500 rows, but its still running away
I guess that’s your answer then, updating many of those rows would of course take more time. So maybe you’ll have to run several queries and update only a fraction of the rows each time.
It’s likely that the large number of rows is a factor yes. But 100,000 is not an unmanagable amount of rows. How long does it take to run the select version of the query? I mean this:
SELECT
*
FROM
invoiceLIVE
INNER
JOIN invoice
ON invoice.INVOICE_Number = invoiceLIVE.INVOICE_Number
AND invoice.COMPANY_Number = invoiceLIVE.COMPANY_Number
What results do you get for explain on the above query?