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