Disabling or Limiting Post Revisions in WordPress
PHP

Disabling or Limiting Post Revisions in WordPress

One of the great features that WordPress has to offer its users is revision management. WordPress will automatically create a new revision every time you save a post, or whenever you preview it. For most WordPress installations, controlling revisions will not be required, and they won’t require maintenance. For larger sites, or sites that are very space constrained, you can limit or disable the revision management functionality of WordPress.

[ Read More ]

DB2 Maintenance Script (RUNSTATS, REORG)
Database

DB2 Maintenance Script (RUNSTATS, REORG)

I had a local copy of a WebSphere Commerce database that was performing horribly, and I decided to create a script that would retrieve a list of all available tables for all non-system schemas, and perform a RUNSTATS and REORG for those tables.

[ Read More ]

SQL Query to Determine a Master Catalog ID
Database / WebSphere

SQL Query to Determine a Master Catalog ID

Working on a project recently I found the need to determine the master catalog for a list of stores within a WebSphere Commerce database. Seeing as a WebSphere Commerce instance can contain a variety of stores, ranging from your traditional Consumer Direct model to a more extensible Extended Site model, I generated the following query which can be run against the WebSphere Commerce database to properly determine the master catalog identifier for each store.

[ Read More ]