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
