performance charts

I never use OE managment before, not sure if there is a web version and I think web version has an edge when it comes to monitoring. The first version of charts I built was on OFC(open flesh chart), it is a great open app. It has more updated version now, working more with JSON(if I remember it correctly). One thing I needed and it doens't have is the abablity to see the trends unless you draw it, that's something Google charts can provide. Have you ever noticed on the google finance charts, the annotatedtimeline chart. it lets you highlight the high/low point, or any points you want, also you can see the trend of your data for a day, a month, or a year or more. if you have a Progress database but don't have WS licence, you can try out one of those php wrappers listed on the site. With webspeed, it would be easier to access that way.

the process of getting the data is something to ponder on carefully, the more "real time" you want to have, the more times you will have to reach out to either get the data or have it delivered to you, either way it is overhead. I've heard the _lock table can affect users if not carefull, not sure about all the details on that one. so you can do either cron or have a long-runing(or a few long running) jobs to get the data for you. On the other hand after you get the data, you can again, use cron or long-running jobs to parse the files/data and insert them to the your performance database. those are the meat part of the whole performance. The chart is straight forward, and give user great flexiblility to view the data and be alerted on the abnormal movements.