#1 2017-07-27 23:34:57

restneophyte
Member
Registered: 2014-11-18
Posts: 26

CreateAndFillPrepare suddenly very slow

I am using 'Delphi 10.1 Berlin' and the latest version of 'mORMot' to access a 'mySQL' database via a 'TSQLRestClientHTTP' component.

Suddenly all my calls to 'CreateAndFillPrepare' are very slow. They used to be fairly fast. Now they take more than 15 seconds to execute.

For example, the call below takes 21 seconds.

iMyProductRecord := TMyProducts.CreateAndFillPrepare(iClient, 'ExpireOn', 'ID = ?', [aProductID]);

I have not changed my code for the past couple of weeks.

Has anybody else experienced this problem and/or knows how to address it?

Offline

#2 2017-07-28 08:04:39

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,713
Website

Re: CreateAndFillPrepare suddenly very slow

Doesn't ring any bell, sadly...

Offline

Board footer

Powered by FluxBB