[Babase] query for marie

Susan Alberts alberts at duke.edu
Fri May 11 15:35:54 EDT 2007


>
> Put "EXPLAIN ANALYZE" in front of
> your SELECT statements to do benchmarks.  Always run the SELECT
> twice this way and take the results from the second run, otherwise
> you won't get reproducible results because of disk read caching.
> It's also a good idea to do benchmarks on a more idle system,
> so today wouldn't be good.

Karl, thanks for the tips in your emails today, this one especially  
is very useful and we will look into this more.

>
> What _is_ worth thinking about is the kind of optimization you made,
> where you did members.date = cycpoints.date and so cut the number
> of rows down by a couple of factors of 10, at least, rather than
> doing what I did and later eliminating the rows using DISTINCT.

Yes, this is important I agree.

Susan

-----------------------------------------------
Susan Alberts, Dept. Biology, Duke University, Durham NC 27708. Phone  
919-660-7272, Fax 919-660-7293. alberts at duke.edu



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.eco.princeton.edu/pipermail/babase/attachments/20070511/f2140b8e/attachment.html


More information about the Babase mailing list