mORMot Open Source

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?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: CreateAndFillPrepare suddenly very slow

Doesn't ring any bell, sadly...