wesley tanaka


exiftool: preserve last modified timestamp


I'm looking to modify the EXIF/IPTC meta information in a Canon RAW file (.CR2). In particular, I'm trying to add title, description (subject) and keywords tags to the file before uploading it to dreamstime. However, I do not want to change the last modified date stamp of the file.

Dell LCD monitor way too bright


I discovered that my LCD monitor (Dell E176FP) was way too bright, so I adjusted the gamma up by editing my xorg.conf file to add a Gamma line as described an article on linux.com. In fedora 7, the xgamma program is contained in the xorg-x11-server-utils package.

Updating linux heroes of might and magic 3 to 1.3.1a


wget ftp://mirrors.dotsrc.org/lokigames/updates/heroes3/heroes3-1.3.1a-unified-x86.run

_POSIX2_VERSION=199209 ./heroes3-1.3.1a-unified-x86.run --keep

Download http://downloads.sourceforge.net/goldenfiles/loki_patch-fix-0.1.tar.gz

tar xvfz loki_patch-fix-0.1.tar.gz

cp Loki_patch-fix/fixedpatch heroes3-1.3.1a-unified-x86/bin/Linux/x86/loki_patch


diff .po files


I had two .po files (one of which was saved from poEdit) which had their strings in a different order, making the unix diff utility useless in looking at the differences between them. Loading and re-saving the other .po file inside poEdit sorted the strings in the same way, allowing diff to work quite well.

Using xscreensaver hacks in gnome screensaver in Fedora Core 5, 6, 7

Pretty easy:
sudo yum -y install xscreensaver-extras-gss xscreensaver-gl-extras-gss

Drupal 5 _drupal_cache_init() performance


_drupal_cache_init() will attempt to fetch the page to be generated from the cache_page table, even if caching is turned off on a Drupal 5 site.

Actually, this seems like a bona-fide bug, so I think I'll file it.

Looking at the Drupal CVS source code, it appears the bug is still in Drupal 6 at the moment.

Drupal 5 system table performance


Every page view in drupal runs this query:

SELECT name, filename, throttle FROM {system} WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC

Adding a key

ALTER TABLE {system} add key wtanaka_modulelist(type(6),status,weight,filename);

seems like it should help in theory. The explain changes from this full table scan with filesort:

Speeding up performance of Drupal 6 themes that call l()


CVS Drupal 6's l() function calls check_url every time it gets called, which is sort of slow. I'm not totally sure why -- that kind of cleaning should be handled inside url() (and it looks like it already is). But I'm not confident enough to get rid of it in my l() backport module.

Database index for Drupal's Who's New Block


Trying to speed up user_block's block #2 (Who's New) which currently uses a query that needs a filesort. Although the "status" column can only be 0 or 1, the query is expressed as status != 0 -- I think someone expects the status column to have more possible values in the future.

Syndicate content
by Wesley Tanaka