The first query shown in the log is the one I actually tells ADO.Open to run... however just after that one it runs two more (the two tables includes in the first query) select * queries... Why?? This slows down the ADO a lot. Even Jet4.0 doesn't do that on the same query and is therefore about 100 times faster on this particular query.
Below is the log... 020307 8:38:03 55 Query SELECT Sum(tblAssignmentProducts.Quantity * tblAssignmentProducts.ModPrice) AS ExtendedPrice, Sum(tblAssignmentProducts.Quantity * tblProducts.Price) AS ExtendedInPrice FROM tblAssignmentProducts INNER JOIN tblProducts ON tblAssignmentProducts.ProductID = tblProducts.ProductID WHERE (tblAssignmentProducts.AssignmentID = 10002) AND (tblAssignmentProducts.ShowRecord = 'True') 55 Query SELECT * FROM tblAssignmentProducts 55 Query SELECT * FROM tblProducts Ruben --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php