ValentinaServer as a plugin

Ruslan Zasukhin sunshine at public.kherson.ua
Mon Sep 13 17:47:53 CDT 2004


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?
> 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!

Another important difference.

Client-side cursor always is read only.

Server side allow you Add, Update Delete records.

I think server side is very good when you are on the same computer,
If you have local fast intranet.


-- 
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
-------------------------------------------------------------



More information about the Valentina mailing list