Sergey,
I'm having a problem with these 2 commands. The first takes 29 seconds to
run against 849,000 records on the local PC, and the second takes 40 seconds.
cAlias contains the name of a temp table, created on the fly in the query
routine. There is an index on DtId. Since this will be running on network data, and
is called when the user clicks Save, they are entirely too fast.
I'm tring to remove thse records before they are re-saved. Any ideas on hwo to
do this faster?
DELETE Commits;
FROM Commits;
JOIN &cAlias ON &cAlias..DtId = Commits.DtId
DELETE FROM Commits;
WHERE DtId IN;
(SELECT DtId FROM &cAlias)
>In addition, you can combine the first select with DELETE/UPDATE
DELETE MyTable ;
> FROM MyTable ;
> JOIN (SELECT Id FROM MyTable WHERE SomeValue = 1) MyCursor
> ON MyCursor.Id = MyTable.Id
>
>
>>Thank you!
>>
>>>In VFP9 only
>>>DELETE MyTable;
>>> FROM MyTable;
>>> JOIN MyCursor ON MyCursor.Id = MyTable.Id
>>>
>>>UPDATE MyTable;
>>> SET SomeField = SomeValue;
>>> FROM MyTable;
>>> JOIN MyCursor ON MyCursor.Id = MyTable.Id
>>>
>>>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people