Leginon

We'd like to add a few more statistics (#stackes, class averages, maps) as well to these pages. When Eric returns, lets meet and discuss.

Based on our last status meeting, the script is complete, however we were still deciding on how to distribute it. It takes about 20 minutes to run and brings the web server to a crawl, so we don't want people to run it when the web server is busy. We also don't want to run it in the middle of the night when a visitor is trying to collect data. So it seemed best not to have it run automatically, just when the user initiates it. This could be from a web page, but we will need to make it clear that it should only be run when the web server is relatively free. Eric has most likely made some progress since then.

OK thanks. But can I view the results please?
Are there some slower parts of it that can be left out expect for when absolutely neessary and other parts that can run routinely?
Wll it be slow on everyone's systems or jsut ours because we have so many projects?

I have the page in svn now. Before it update to betamyamiweb, you can see it at:
http://cronus3.scripps.edu/~erichou/myamiweb/project/runStat.php

There still some numbers not in the page yet according to Bridget's doc. The numbers in runStat.php is want I did when we was writing Appion proposal.

Thanks.

Eric

OK, is this still on your list to get me the rest of the numbers and graphs generated on a single page?
Also how do we send these to the other Leginon/Appion users? i.e. can we jsut send them a script to run that generates a file.
I would like tot get this finalized and shipped off this week.

Yes, I would keep adding the numbers base on the requested doc. But I need some help from others also. There are couple numbers I don't know where them stored at.

how do we send these to the other Leginon/Appion users?
- If the users use svn to setup their myamiweb, they can just do svn update. Otherwise, they need to get it at the next release. Or we need to teach them how to put the files in the right place in their file system. I am trying to put everything in one file, but sometimes generate some numbers required changes from other support file. If that's the case, users will need to add a new file and update couple different files (sounds dangerous).

The other way is to write a command line script, then we might be able to send them a file to generate these number, but it won't have any interface (no tables or graphic).

Thanks.

Eric

Add 7 days caching in to the report, so the page does not take too long to display back to user.
You can visit the page at: http://cronus3.scripps.edu/betamyamiweb/project/runStat.php

Thanks.

Eric

No problem, I will get this fix this week.

Thanks.

Eric

Hi
Basically the DB statistic page is done, the only thing not there is the graphical summaries for Appion processed session and images.
To display the graphic for each ap database is pretty easy, but if we want to combine all of them it's a bit of work. First of all, each one created at different time. And they need a sql temporary table to hold the temporary query data before the finial calculation.
I am still investigating the strategy between using complex sql queries or the php mix with sql query.

But so far, you can visit the report page at:
http://cronus3.scripps.edu/betamyamiweb/project/runStat.php

Thanks.

Eric

updated database schema xml file for new myamiweb installation.
There still an database update script needs to be done before class this issue.

Eric