VirtualQuery questions
Posted: Sat 02 May 2020 07:14
2 questions:
1 - I have 2 data sets, one a sales header (31000+ rows), and another a sales lines (120000+ rows), both stored in virtual tables. I use VirtualQuery to run a query to join the 2 data sets like this:
SELECT ds1.SalesOrderID, SUM(ds2.OrderQty)
FROM ds1
INNER JOIN ds2 ON ds1.SalesOrderID = ds2.SalesOrderID
GROUP BY ds1.SalesOrderID
The query takes extremely long to run. Is there a way to improve the performance? I already disabled the updates for both data sets.
2 - does BreakExec allow you to cancel a query? I tried to use it to cancel an active VirtualQuery, but nothing happens. I'm running the query in one thread, and cancelling it from another thread.
Thanks in advance.
1 - I have 2 data sets, one a sales header (31000+ rows), and another a sales lines (120000+ rows), both stored in virtual tables. I use VirtualQuery to run a query to join the 2 data sets like this:
SELECT ds1.SalesOrderID, SUM(ds2.OrderQty)
FROM ds1
INNER JOIN ds2 ON ds1.SalesOrderID = ds2.SalesOrderID
GROUP BY ds1.SalesOrderID
The query takes extremely long to run. Is there a way to improve the performance? I already disabled the updates for both data sets.
2 - does BreakExec allow you to cancel a query? I tried to use it to cancel an active VirtualQuery, but nothing happens. I'm running the query in one thread, and cancelling it from another thread.
Thanks in advance.