I have an SQL query that takes about 80ms.
On the server side (RemoteDBModule.ProcessRequest), RemoteDB takes about 200ms for it.
On the client side, however, this statement takes more than 9 seconds:
6 seconds in Performer.Request(CmdOpenFields) and 3 seconds to build the TableData
This statement is executed within a thread, fetching Data paged.
The selected table contains only 35.000 records.
SQL Limit is set to 2000.
Do you have any indications as to where I should investigate further?
Hard to tell without a profiler. Do you have big-sized columns in that table, like big blobs?
no, it only fetches
id (guid)
article_number (string)
short_caption (string)
short_caption is a heavy subselect, not an existing column on my article entity.
But I just find out, that these 6 seconds are lost within my TLoggableResponse.GetContentAsStream
This is initialized using
THttpEngine.CreateEngineFunc := TLoggableEngine.DoCreateEngine;
And is using same implementation as THttpResponse.GetContentAsBytes, so that I'm able to log any response body, as I asked in Logging Response Body - #4 by wlandgraf
I'm just a little bit confused, how TRemoteDBProvider.Open works without accessing THttpResponse.GetContentAsBytes at any time
Sorry, I didn't understand your last question, can you please elaborate?
nevermind there is no opened question anymore.
Thanks for your hints.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.