• Checking for string permutation

    January 20, 2010

    A permutation is a change of places. Thus, ‘lolhe’ is a permuted ‘hello’ (commonly referred to as ’scrambled text’).
    I wish to present an SQL solution for checking if two strings are permutations of the same text.
    About permutations
    So, if ‘lolhe’ is a permutation of ‘hello’, then ‘hello’ is a permutation of ‘lolhe’, as well; and both [...]

  • Misimproving performance problems with INSERT DELAYED

    January 14, 2010

    INSERT DELAYED may come in handy when using MyISAM tables. It may in particular be useful for log tables, where one is required to issue frequent INSERTs on one hand, but does not usually want or need to wait for DB response on the other hand.
    It may even offer some performance boost, by aggregating such [...]

  • mycheckpoint rev. 76: OS monitoring, auto deploy, brief HTML and 24/7 reports

    January 5, 2010

    Revision 76 of mycheckpoint comes with quite a few improvements, including:

    OS monitoring (CPU, load average, memory)
    Auto-deploy
    Improved charting
    Brief HTML reports
    24/7 charts

    OS Monitoring
    When monitoring the local machine, mycheckpoint now monitors CPU utilization, load average, memory and swap space.
    This only applies to the Linux operating system; there is currently no plan to work this out for other operating [...]

  • Tales of the Trade #2: The Oracle-Sun deal

    January 3, 2010
 
Powered by Wordpress and MySQL. Theme by openark.org