by Hengki (1 Submission)
Category: Databases/Data Access/DAO/ADO
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: 
(4 Votes)
Searching and Browsing is among most common task for database application.
fast search is definitely is a must for good database application,
specially application with high transaction load like Point of Sales.
i use this because i have difficulty in displaying data to user fastly,
at first time i use grid by bound it to recordset and did not notice that it is
only displaying +/- 2000 record until my customer tell me that it is did not show
all the data ( what a good programmer :) ).
then i search msdn and found that it is ms hflexgrid limitation ( WOW ). and i
start to use the clip function just like msdn told me to. and my customer say
"i wonder why yours is slower than my foxpro program", i reply "because foxpro
only display data page by page because foxpro procedural programming", "why dont
you display it like foxpro" he ask again.
that is the story of good programmer :) who learn from good non programmer.
hope it is usefull for you.
Download Fast Grid Loading (15 KB)
VBcoders