Hi
I have a database with only two linked external sources:
A spreadsheet and a SharePoint list.
I update the SharePoint list with data from the spreadsheet. A total of 22 columns will be checked for changes.
Here is a part of the SQL string I use to update the SharePoint list, so the SQL string is a bit longer with 22 columns.
My problem is the query is very slow, because it needs to check all 24.000 records for changes.
How can I speed the process up?
Best regards
Morten
I have a database with only two linked external sources:
A spreadsheet and a SharePoint list.
I update the SharePoint list with data from the spreadsheet. A total of 22 columns will be checked for changes.
Here is a part of the SQL string I use to update the SharePoint list, so the SQL string is a bit longer with 22 columns.
Code:
UPDATE [Supplerende kreditor stamdata]
INNER JOIN SyncSP
ON [Supplerende kreditor stamdata].[Kreditor nummer] = SyncSP.[Kreditor nummer] SET [Supplerende kreditor stamdata].Kreditortype = [SyncSP]![Kreditortype]
WHERE [Supplerende kreditor stamdata].Kreditortype is null OR [Supplerende kreditor stamdata].Kreditortype <>[SyncSP]![Kreditortype];
My problem is the query is very slow, because it needs to check all 24.000 records for changes.
How can I speed the process up?
Best regards
Morten