Subject | Re: [IBO] fetching some records |
---|---|
Author | Svein Erling Tysvær |
Post date | 2001-07-19T12:06:06Z |
Hi Justas, I'm just curious.
What is the point of fetching 10 000 records to show in a form? It sounds
like desktop programming, and not client/server. The short term memory of a
human being is normally 5-9 units, no way can (s)he consume the contents of
10 000 records. You may be doing the right thing if you're just
transforming an existing application and need to get it up and running
before yesterday, but once you get the time you probably ought to redesign
your program to only get the records of interests (e.g. if interested in
records inserted lately do something like SELECT INTERESTINGFIELD1,
INTERESTINGFIELD2 ... FROM TABLE WHERE
REGISTRATIONDATEWHICHISOFCOURSEAFIELDINYOURTABLE >= :ParamDate).
Set
What is the point of fetching 10 000 records to show in a form? It sounds
like desktop programming, and not client/server. The short term memory of a
human being is normally 5-9 units, no way can (s)he consume the contents of
10 000 records. You may be doing the right thing if you're just
transforming an existing application and need to get it up and running
before yesterday, but once you get the time you probably ought to redesign
your program to only get the records of interests (e.g. if interested in
records inserted lately do something like SELECT INTERESTINGFIELD1,
INTERESTINGFIELD2 ... FROM TABLE WHERE
REGISTRATIONDATEWHICHISOFCOURSEAFIELDINYOURTABLE >= :ParamDate).
Set
>what timeout properties? I want to do such thing. When user opens form with
>dataset, dataset has fetched some records (not much). if user goes to last
>record, it takes a long time to go there, becouse in my case table is very
>big. so i want to create timer with for ex. 2000 interval and that it would
>fetch for ex. 10000 records in every 2 sec. and it gets so: if user opens
>form, waits for a long time, press LastRecords and it faster goes there
>(becouse due timer fetches, more records are fetched). so the problem is: is
>there any method like IBODataSet.FetchNextRecords(10000)?