Archive for May, 2009

DB Tuning – Sizing I/O

Tuesday, May 19th, 2009

Cache is an important aspect of any system. However, cache can be easily saturated and invalidated with a single scan or a large query. With this in mind it is necessary to know your system usage and pick performance capabilities. Disk I/O is not fast. The following table outlines the limits: ...

Oracle performance FAQ

Friday, May 15th, 2009

The following article provides a good summary of Oracle performance tips: http://www.orafaq.com/wiki/Oracle_database_Performance_Tuning_FAQ In addition, see an article on extending SGA memory block on Windows 32-bit platform.

Mobile data exchange protocol

Saturday, May 9th, 2009

I started to look into different options to exchange data between mobile device such as blackberry and a typical REST web service. The following tutorial looks into different options. It basically chooses JSON over other available options for the perfect balance of development simplicity and data overhead: http://developerlife.com/tutorials/?p=624

Epoch Converter

Thursday, May 7th, 2009

This site provides a good conversion tool to find out UNIX date for a regular timestamp: http://www.epochconverter.com/ Actually found this one to provide wrong data. However, the idea is neat. I'll write my own service then... I spent more time... the timestamp that is provided by the site doesn't include millisecs. If you ...

How to send SMS to your phone

Thursday, May 7th, 2009

I was looking into reusing SMS for communication with my cell phone. The following site suggested a very nice trick: http://web500.us/how-to-send-text-messages-or-pictures-from-pc-to-cell-phone/ If you are sending email to the Rogers Wireless subscriber, he has to be subscribed for the Email-SMS gateway. Each forwarded SMS costs 5c. If subscriber is not subscribed for a ...

Cron Expression

Wednesday, May 6th, 2009

For cron expression syntax see the following link: http://quartz.sourceforge.net/javadoc/org/quartz/CronTrigger.html