Code and Coffee

Archive for July, 2006

JDbMonitor - Monitor JDBC Performance

Posted on July 11, 2006, under Development.

JDbMonitor is a tool to monitor and analyse SQL performance in any Java/J2EE application. Provides an effective GUI client to troubleshoot performance issues uncover database bottlenecks.

Features:

  • Real time monitoring of SQL execution
  • Works with any application that uses JDBC
  • Effective GUI to analyse SQL performance data
  • Detailed timing information for each SQL statement executed including preparation time, execution time, data transfer time as well as number of records retrieved
  • No code change required
  • Suitable for monitoring production systems
  • Easy to configure and use

Why Use It?

  • Troubleshoot performance issues in production systems to uncover database bottlenecks
  • Constantly keep an eye on your applications for ’slow’ SQL statements that can potentially cause problems
  • Find out exactly what SQL statements are executing in your Java application
  • Determine database bottlenecks during development & testing phases to identify areas to improve and SQL statements to optimize
  • No more writing System.currentTimeInMillis() between your JDBC calls to capture SQL timing information
  • No more going through lines and lines of text based SQL log files to analyse SQL timing information

Popularity: 2% [?]

No Comments



PHP Accelerator

Posted on July 10, 2006, under Development.

PHP, like other languages including ColdFusion and ASP suffers from one major set back; it compiles on the fly. Basically this means that your web server has to compile your PHP or web script every time it is executed, as apposed to other languages where you compile it once and deploy the executable. As you probably know, or can figure out this can lead to unnecessary overhead on web servers. There are a lot of accelerators on the market, some for pay and some for free, that will accelerate this process by caching PHP scripts in the compiled form, eliminating that step every time the script is executed.

I have been using these accelerators for a little over a year on my web servers and PHP projects. Specifically I use ionCube PHP Accelerator for reasons including:

  1. It’s very easy to install, less than five minutes.
  2. It does not make a mess and cleans up after itself.
  3. It has enough options for customization, but not too much that makes it overwhelming.
  4. It has the free price tag.
  5. It supports numerous platforms and PHP builds.
  6. It is smart and knows when a PHP script has been updated, and it needs to recompile.
  7. It delivers results.

PHP Accelerator touts delivering five to ten times faster results, and I can say those numbers sound correct from my findings. I suggest anyone developing in PHP to install this accelerator, especially if you are on a shared hosting provider. PHP Accelerator will free up resources that might be working too hard. As always it is recommended testing this out in a sandbox environment with your PHP applications, before rolling it live. I have never had a problem with it, but I do not want to be the reason your applications go dark.

Popularity: 2% [?]

1 Comment



  Recent Entries »