[VSRV] Overall speed versus open/close trick

[X Y]

it MUST be an error on my part. Let me write simple
test instead of integrating it into a big system

--- Ruslan Zasukhin <sunshine at public.kherson.ua>
wrote:
> 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
>
-------------------------------------------------------------
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com