G
Guest
Does any one knows how to speed up an add/append to table query of 200,000
records.
This query sum up invoice totals by adding taxable and not taxable line
items and placing the result in a table for another query to see further see
if payments have been made.
The query without append/add to table runs fast but crawls when adding the
result to table (I assume it would be as slow too, If I didn't add the result
to table but sent it directly to report).
Any suggestions!
records.
This query sum up invoice totals by adding taxable and not taxable line
items and placing the result in a table for another query to see further see
if payments have been made.
The query without append/add to table runs fast but crawls when adding the
result to table (I assume it would be as slow too, If I didn't add the result
to table but sent it directly to report).
Any suggestions!