Re: [Gnumed-devel] publicdb.gnumed.de performance

[Sebastian Hilbert]

Am Samstag, 7. Mai 2011, 19:30:39 schrieb Slappinjohn:

Hi Marc,

Some comments.
 
> it's not only a problem for using the public db. In my practice I'm
> running a GNUmed-server at home and connect via openvpn and dyndns. Most
> of the time I'm waiting for a new patient to show up or changing tabs or
> unfold the encouter tree. If anything can be done on performance
> matters, it would be great. All the other network services (CUPS,
> davical) are working just fine

Not surprising at all. Server is not that bad. There are fundamental issues.

With the current setup all data and all request, all queries run to the server 
and back. Each time a query is made it runs e.g. 200ms. So the more queries 
the longer it takes.

On my local LAN

--- localhost.localdomain ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2001ms
rtt min/avg/max/mdev = 0.042/0.045/0.047/0.002 ms

ping server2.gnotary.de
PING server2.gnotary.de (94.101.41.9) 56(84) bytes of data.
64 bytes from mail.hilbros.de (94.101.41.9): icmp_req=1 ttl=56 time=43.8 ms

See the difference ?

So the only way to speed this up is to reduce the number of queries. I am not 
sure this can a) easily be done b) make a difference

I am not even sure it makes a difference wheather you are on a 1Mbit 
connection or 10MBit connection.

In your case I would set up NX. That way you would work *on* the server. No 
round trips. All that is transmitted to you is the screen output. *Much* more 
efficient.

Check NX, FreeNX and friends. Forget VNC.


Best regards,
Sebastian

> 
> Greets
> 
> Marc
> 
> Am 29.04.2011 10:22, schrieb Sebastian Hilbert:
> > Hi all,
> > 
> > I am looking for some real world figures regarding our public server ,
> > its performance and the usability of the publicdb
> > 
> > When I fire up GNUmed and connect to the public database it takes 26
> > seconds from having typed kirk in the patient search field and hitting
> > enter (to initiate the search) to the user interface becoming responsive
> > again and the clock at the lower right ticking again.
> > 
> > It takes another 4or 5 seconds until the patient name is listed in the
> > the patient search box and the user interface has switched to the first
> > plugin.
> > 
> > I wonder if this is as fast as it gets or if there is room for
> > improvement.
> > 
> > The server hosting the public db is physcially located 5km from my home
> > but my traffic is routed through Frankfurt
> > 
> > I am on a 4,8MBits download/0,3MBits upload connection
> > 
> > traceroute publicdb.gnumed.de
> > traceroute to publicdb.gnumed.de (94.101.41.9), 30 hops max, 40 byte
> > packets using UDP
> > 
> >  1  xxxx (192.168.xxx.xxx)  1.030 ms   1.296 ms   1.052 ms
> >  2  dslb-188-102-224-001.pools.arcor-ip.net (188.102.224.1)  15.635 ms
> > 
> > 16.448 ms   17.118 ms
> > 
> >  3  88.79.24.253 (88.79.24.253)  22.784 ms   21.898 ms   21.008 ms
> >  4  92.79.212.173 (92.79.212.173)  73.170 ms   72.261 ms   71.523 ms
> >  5  92.79.213.122 (92.79.213.122)  31.231 ms   42.388 ms   41.634 ms
> >  6  decix.ffm.de.tnib.net (80.81.192.79)  35.348 ms   36.501 ms   28.201
> >  ms 7  hlkomm-gw.ffm.de.tnib.net (81.92.174.174)  29.037 ms   29.101 ms 
> >   28.189
> > 
> > ms
> > 
> >  8  LMA2.hlkomm.net (85.232.2.157)  42.259 ms   42.040 ms   42.557 ms
> >  9  LMA2.hlkomm.net (85.232.2.157)  43.318 ms   44.040 ms   44.879 ms
> > 
> > 10  mail.hilbros.de (94.101.41.9)  48.336 ms   48.669 ms   49.708 ms
> > 
> > Please report your figures.
> > 
> > Any help is appreciated.
> > 
> > Sebastian
> > 
> > 
> > _______________________________________________
> > Gnumed-devel mailing list
> > address@hidden
> > https://lists.gnu.org/mailman/listinfo/gnumed-devel
> 
> _______________________________________________
> Gnumed-devel mailing list
> address@hidden
> https://lists.gnu.org/mailman/listinfo/gnumed-devel