Hello,

Good morning.
The procedure using is shown below

Set rsFill = New ADODB.Recordset
rsFill.Open sSQL, g_dbConnection, adOpenForwardOnly, adLockReadOnly, adCmdText

With g_iGridName(iGrd)
.BeginUpdate
.FillFromRS rsFill, , sGridTableColName
.AddRow
.EndUpdate
End With
Set rsFill = Nothing

So what is the question?

Taking a long time to load the data into the grid.
Please advise what could be the reasons for this delay and home to improve the performance.

The load time depend on the driver used to retrieve data from the database and other features provided by the DB and ADO Recordset connected to it. Try to play with different types of recordsets for the same data if possible.

The FillFromRS is a general method developed to process any possible ADO/DAO data sources, so that in the general case it may work slowly because of its versatility.