ValentinaServer as a plugin

[Ruslan Zasukhin]

On 9/13/04 5:38 PM, "Eric Ferrer" <wonderfef at noos.fr> wrote:

>>> All I see is that ClientSide is faster, so what's the point of ServerSide?
>> IF you will select 100,000 records from million table,
>> Then Server-side will be faster because it will not send all found records
>> by network to client computer.
> OK, I see, but when you start looping into the cursor (server-side), you
> generate some traffic in the network. So creating a large serverside cursor
> is faster, but reading it record after record is slow anyway. Am I right?

Yes.

But keep in mind, most probably user will NOT read all 100,000 records.
He will jump here, jump there....

Also note, exists middle-mode:  Bulk Cursor.
It combine features of server and client side cursors.

It keep 100,00 record on server, but also it create buffer for e.g. 50
records on client and load them as bulk.


> Here are the results of my tests on a table contained 245'000 recs:
> Client side :   16'134 ticks to build the cursor
>                   115 ticks to display the result in a ListBox

> ServerSide :   40 ticks to build the cursor
>                   40'912 ticks to display the result in a ListBox
> 
> Anyway, I never use such huge cursors

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------