Mike,
I used Explain and I don't see anything that says indexes. I use the
Control Center for all of my stuff. Would it show in there?
88 rows are returned both in mySQL and Access.
>>> Brent Baisley <[EMAIL PROTECTED]> 1/26/2004 2:03:10 PM >>>
How did you determine the bottleneck was the l
The first query that you wrote took 5.93 seconds with count of 523. The
second query took so long I aborted it. The way I figured it was the
'Left Join' was by running the following query.
#1: This takes out the join and sets 'Products.ProductID =
tblInvTransaction.ProductID' to join the two t
How did you determine the bottleneck was the left join? I would have
thought it was the WHERE clause.
I'd be curious what the times are on these queries:
SELECT count(*) FROM Products
LEFT JOIN tblInvTransaction ON Products.ProductID =
tblInvTransaction.ProductID Where ((NSIPartNumber Like "%02-0
At 02:18 PM 1/26/2004, you wrote:
Jacque Scott wrote:
I have a fairly simple query where I feel it takes too long to run.
SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
Products.USPrice, Products.VendorPart, Products.Description ,
Products.ProductID, Sum(tblInvTransaction.Qty) AS S
In Access 2.0 and mySQL Products.ProductID is indexed but
tblInvTransaction.ProductID is not. I tried to set
tblInvTransaction.ProductID as indexed but it still took a long time.
>>> Daniel Kasak <[EMAIL PROTECTED]> 1/26/2004 12:18:46 PM
>>>
Jacque Scott wrote:
>I have a fairly simple query whe
Jacque Scott wrote:
I have a fairly simple query where I feel it takes too long to run.
SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
Products.USPrice, Products.VendorPart, Products.Description ,
Products.ProductID, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products
LEFT JOIN t
I have a fairly simple query where I feel it takes too long to run.
SELECT Products.NSIPartNumber,Products.Cost, Products.ModelNo,
Products.USPrice, Products.VendorPart, Products.Description ,
Products.ProductID, Sum(tblInvTransaction.Qty) AS SumOfQty FROM Products
LEFT JOIN tblInvTransaction ON
