Patch so slow to sql

(0) Share

Report

Posted on by rvdhorst

193

Hi All,

I need to patch about 40 records to a SQL server. All records must be done. A filter is not possible. Only the patching takes about 4 minutes. Is this correct?

ForAll(colRoomSetupInformationTemp,
Patch('Room.RoomSetupInformation', Defaults('Room.RoomSetupInformation'),
{LunchTijd:colRoomSetupInformationTemp[@LunchTijd],RES_ID:colRoomSetupInformationTemp[@RES_ID],

Vestiging:varVestiging,Lokaal:colRoomSetupInformationTemp[@Lokaal],
LunchTijdVoorkeur:colRoomSetupInformationTemp[@LunchTijdVoorkeur],

Opmerking:colRoomSetupInformationTemp[@Opmerking]}));

Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Try this:

ForAll(colRoomSetupInformationTemp,
Patch('Room.RoomSetupInformation', Defaults('Room.RoomSetupInformation'),
{

LunchTijd: LunchTijd,

RES_ID: RES_ID,

Vestiging: varVestiging,

Lokaal: Lokaal,
LunchTijdVoorkeur: LunchTijdVoorkeur,

Opmerking: Opmerking

}

)

);

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!

Was this reply helpful? Yes No
rvdhorst 193 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Nogueira1306

The first 7 to 9 records go fast. After that it takes a very long time. Could this be related to SQL?

Regards,

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

SQL and the ammount of data you have... It is "normal"...

Was this reply helpful? Yes No
rvdhorst 193 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the answer.
Should Dataverse or Sharepoint be faster?

Was this reply helpful? Yes No