Same thing in XE5. In addition, additional traffic and all this client-server thing require> 5 Mbit per second (!) For normal operation. I use only TFDConnection and TFDQuery. Specially for MySQL, the speed coincides with the Delphi components and the third-party driver (libmysql.dll). If you do not have FireDAC, you can replace TFDQuery with TSQLQuery. Here is the procedure for filling the grid of rows:
procedure SelGrid(sql:ansiString;Q:TFDQuery;grid:TStringGrid); var i: integer; begin Q.Close; Q.SQL.Text:=''; Q.Open(sql); grid.ColCount:=Q.FieldCount; grid.RowCount:=1; while not Q.Eof do begin for i := 0 to grid.ColCount-1 do grid.Cells[i,grid.RowCount-1]:=Q.Fields.Fields[i].AsString; grid.RowCount:=grid.RowCount+1; Q.Next; end; Q.Close; if grid.RowCount>1 then grid.RowCount:=grid.RowCount-1; grid.Row:=0; //AutoSizeGridColumns(grid,30,200); end;
This is a VCL string grid. Of course, you are dealing with updates and so on, but you will not have performance problems.