[DAS] Re: LDAS server limits

[Tony Cox]

On Fri, 21 Jun 2002, Tony Cox wrote:

+>On Fri, 21 Jun 2002, Lincoln Stein wrote:
+>
+>OK, lets try it. I've just kicked off a database load - we'll see what
+>happens... :)
+>

Well, I finally got a bit bored of waiting for the DB to load so I killed it off
at 41,278,000 records. That's just under 50% of the total data.

The performance is still excellent though, I couldn't see any major problem with
running this kind of database on our production machines. Of course you get a
lot of data back so you have to wait for it to travel over the wire - but
strictly from the point of selecting the features it is no problem at all.

Tony

+>
+>
+>+>Hi Tony,
+>+>
+>+>I haven't pushed the server above about 6 M features, but performance was not 
+>+>noticeably affected at that level.  I know that it can handle all of dbSNP, 
+>+>because we serve that already.  98M ESTs might be pushing it, but I'd love to 
+>+>find out.
+>+>
+>+>Lincoln
+>+>
+>+>On Thursday 20 June 2002 06:21 pm, Tony Cox wrote:
+>+>> Lincoln,
+>+>>
+>+>> I'm trying to work out how far I can push the LDAS server :) What do you
+>+>> think is the upper limit for number of features to be servered from an LDAS
+>+>> server before performance begins to suffer? The server+mysql is on an ES40
+>+>> with 8GB of memory so it is a box with a bit of grunt.
+>+>>
+>+>> For example I have all dbSNPs mapped to the latest golden path (2.07M)
+>+>> which may be a useful DAS source to publish. There is also a file with 98M
+>+>> ESTs...
+>+>>
+>+>> Tony
+>+>
+>+>-- 
+>+>========================================================================
+>+>Lincoln D. Stein                           Cold Spring Harbor Laboratory
+>+>lstein@cshl.org			                  Cold Spring Harbor, NY
+>+>========================================================================
+>+>_______________________________________________
+>+>DAS mailing list
+>+>DAS@biodas.org
+>+>http://biodas.org/mailman/listinfo/das
+>+>
+>
+>******************************************************
+>Tony Cox			Email:avc@sanger.ac.uk
+>Sanger Institute		WWW:www.sanger.ac.uk
+>Wellcome Trust Genome Campus	Webmaster
+>Hinxton				Tel: +44 1223 834244
+>Cambs. CB10 1SA			Fax: +44 1223 494919
+>******************************************************
+>
+>_______________________________________________
+>DAS mailing list
+>DAS@biodas.org
+>http://biodas.org/mailman/listinfo/das
+>

******************************************************
Tony Cox			Email:avc@sanger.ac.uk
Sanger Institute		WWW:www.sanger.ac.uk
Wellcome Trust Genome Campus	Webmaster
Hinxton				Tel: +44 1223 834244
Cambs. CB10 1SA			Fax: +44 1223 494919
******************************************************