Topic: Limiting records display on tGrid
I come across an older post inquiring about db speed.
Dmitry's advice was to reduce quantity of records to display on tGrid where there are 1000s of records to be displayed. I'm thinking it's very useful and something should be included with all db apps where expected records could be 1000s.
begin
Form1.KeyPreview := True; // If KeyPreview is true, keyboard events occur on the form before they occur on the active control.
Form1.TableGrid1.dbLimit := 500;
end.
Couple of questions:
♦ In the script above "KeyPreview" is a system syntax or to be used on a the form with a component such as button?
♦ What happens after scrolling 500 (in this case, according to script above) records? Is next batch of 500 records loaded automatically in tGrid?
God... please help me become the person my dog thinks I am.