Faster DataGrid Display

[Dixie]

Good morning... I am struggling

I have a stack that has a dataGrid, it displays images and text that it gets from a MySQL database on my computer... Everything works really well locally in the IDE and as a standalone app... It loads quickly and it very responsive. so far, so good.

I have moved the database to my server, I have made my stack into a revlet... Everything still works, but now it is all incredibly slow... On opening the revlet in a browser it takes a few seconds to display and scrolling is very hit and miss, I would not even call it 'jerky'.

Ok.. I had a good read of the 'DataGrid' manual to see what could be done to improve this situation and came across the section (page 160) regarding displaying large amounts of data which points me to setting the dgNumberOfRecords and using the GetDataForLine message.

To get me started trying to improve the speed could someone answer these questions :-

Does GetDataForLine get used instead of the FillInData message ?
Is this the direction to take to try and improve the responsiveness ?

Any help would be really appreciated...

Be well

Dixie