Pawel Sztromwasser wrote: > Hello, > > We have noticed that Experiment overview is very slow for large > experiments (>40 raw bioassays) with many items annotated (mainly > samples). I takes over a minute for some of the experiments to load > overview (or re-validate). I narrowed the issue down to this line: > > List<Annotation> inherited = annotationQuery.list(dc); > > in addAnnotations(..) method (ExperimentOverview.java). > > The list(dc) method takes ~200ms to complete. It is not much, but > multiplied by number of items on the way from rawbioassay down to > biosource (annotations are checked for each of them) and by number of > rawbioassays... it causes most of the delay. > > Does anybody see similar problem? It is probably just a non-optimal > postgres query, if experiment overview works fine on mysql dbs.
Annotations are rather expensive in terms of database access. Each value usually needs 2 separate queries to retrieve. In other words, it is not unusual that it takes a lot of time. /Nicklas ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net
