[VSRV] Overall speed versus open/close trick

[Ruslan Zasukhin]

on 10/15/03 22:52, X Y at xyzabc1010 at yahoo.com wrote:

> Hi All,
> I was wondering if someone can give me some pointers
> on what to do. I was assuming that the speed of
> vserver is much faster than doing the open close
> trick.
> 
> However, when I did a small test to compare the 2 I
> found out that this is not the case and that
> open/close if 5x faster on the same network. Can
> anyone point to me what I might be doing wrong?

Result is really strange!!!

Open/close trick just cannot be FASTER!
BECAUSE

1) when you do open/close you cannot use cache.
    as only you close db its info is removed from cache so
    next time all again will be read.

2) on open Valentina do many enough check
    for example it check indexes and VarChar fields.
    if you work with Vserver your db is always open.

3) when you work with open/close and REMOTE computer,
    you need load into RAM of client computer index pages
    when you do some indexed search.
    when you work with Vserver this task eat ZERO of net.

So just impossible! :-)

What OS was your server and what OS client?
What you use, V4MD client?


> Is it the performance graph a straight line w. vserver
> that as you add more user the performance is the
> constant. Whereas, w. the open/close trick it is
> linear wrt the # if users?

Performance always depend on connected users count.
The more users the slower overall speed of answer.

Other question that with Server, if use A do some big query that take
minute, user B with small query that need 0.1 seconds will not need wait for
user A.
    NOTE in server based on 1.x this still not true.
    Only in 2.0 engine this will works.
 
***
Harry, what exactly you have test and how ?
May be you have test only time of connect ?

Sometimes TCP/IP take few second to establish socket connection, I have see
that. But usually on next time it is faster. When network is warmed up.


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