I've posted a presentation I've written on Performance Tuning ApEx Applications, so if you would like to see that at Open World then, please vote for me!
25 June, 2008
10 June, 2008
In the wonderful world of commercial software development, adoption of technology tends to happen in a bit of a "leap-frog" fashion. For instance, our current release of HAWCS is coded using 2.2.1 of ApEx, but we're getting ready to add some new features to our upcoming 2.1 release that very specifically take advantage of ApEx 3.1 features.
In some ways, this can be helpful. For example, we let the world at large test 3.1 and get to jump straight to the benefits of the 3.1.1 patch. However it can be very frustrating too. I've been reading blogs and forum posts for ages that talk about the great things in 3.1 and have not been able to really try them out on our software.
Another example of playing "leap-frog" is the graphing in our product. In the early days of ApEx, back when dinosaurs like SVG graphs ruled the earth, we took a huge step and decided to use MAANI XML-SWF charts instead. They were way more pleasing to the eye and were cross browser compatible. We spent loads of time building a graphing framework and sewing that into our ApEx application.
Now with 3.1+ of ApEx, Oracle have included the Flash based AnyChart graphing solution directly in their product. Now we have to make the decision as to whether we abandon our home grown framework and the XML-SWF charts in favor of the built in AnyChart solution. Something that makes this a little bit more interesting is that Oracle ships both V3 and V4 of the AnyChart software with ApEx 3.1+
The built in graphs use V3 while the Interactive reports use V4. If you look at them side by side, there is definitely a difference in their style and attractiveness, V4 being far superior in quality and functionality.
So what is a Product Manager to do? I now have 4 choices in front of me.1. Continue to use our home grown XML-SWF chart solution
2. Switch to the built in V3 graphs and wait for Oracle to upgrade THOSE to V4
3. Try to use Interactive Reports for everything I want to graph and just have the default view be the graph
4. Build a new (or alter our current) graphing framework to use the V4 charts
My XP training tells me to do the least amount of work necessary to get the job done, so that would mean staying with option 1, but I know that at some point I will want to move to the built in graphs, if for no other reason, so that we can stop maintaining our complex graphing framework and spend more time on the CORE code that people are actually paying us for.
Anyway, I'm upgrading our development environment to 3.1.1 as I type this, so I guess I'll have to do a little research to see how hard it will be to migrate the SQL statements that drive our graphs into the built in graphing solution.
I'll let you know how it goes.
09 June, 2008
Well, I've finally succumbed to peer pressure. I've been getting hounded by many and varied people to join the infamous blogosphere and splat my thoughts and opinions out on the web for everyone to see.
Now don't get me wrong. I'm a big fan of blogs, and read and/or monitor many blogs every day (see my Blog List to the right). However, I've never thought that I had enough to say to actually add to the wealth of information out there without diluting the quality.
In the last few months though, things have happened that drove me to research things that would have made interesting blog posts, and that I haven't necessarily seen in other places.
Therefore you can add my name to the list of people adding data to the virtual encyclopedia that is the internet.
My subject areas will likely focus on:
- Application Express
- SQL Developer
- Oracle Performance
- Writing Commercial Software
- Software Instrumentation
- MAC (because recent converts are the evangelists)
I look forward to sharing my journey with you.