At 06:29 PM 6/15/2001 +0000, Alexander V.Nevsky wrote:

> Hi, Ann. I stored 20 000 records without touch generator. Then I
>made select of 10 000 firing generator on select each record. I made
>it via component not linked to db-aware controls and waited 1 record
>to be fetched and generator to be fired 1 time.

>I supposed records are visited from access bitmap only when
>fetch is requested. But I see neither 1 increment nor 10 000
>what should be if all records to be fetched are visited
>before fetch.

Ah, OK. That is a side effect of the way InterBase does remote
access. On the server side, it retrieves rows until the data
fills a network packet and sends the whole packet. On the client
side, it unpacks the rows one at a time as the program requests
them. The server may prefetch the next set of rows - I really
don't remember. You got either 4680 rows in a packet or 2340
in each of two packets.

And it will have no effect on TOP.


Regards,

Ann
www.ibphoenix.com
We have answers.