We had a need to search some text files in Windows modified during a certain time range with a given piece of text. This is a network drive that is not indexed, so we couldn’t quickly rely on a windows…
Month: July 2014
Gotcha on automatic PL/SQL recompilation
What is below is taken from an actual analysis of heavy latching and invalid objects after a change was made. This was done in early 2011. For a long period of time, we have avoided making changes that would result…
Apologies for site slowness
All, I am aware the site has been slow for the better part of a month. This morning, I finally took the time to look at the host on which my hosting partner (1and1.com) stores the site. User CPU utilization…
Does java reuse closed sockets when the host still has one open?
We were curious as to what the handoff is between an application that opens a network socket, and how the Linux OS handles it. Let’s assume we do what is below: import java.net.*; public class checkSocket { public static void…
Simulating shopper abandonment in JMeter
It is unrealistic to generate traffic to a website for load testing without taking into consideration the ongoing experience of the virtual shopper. For example, if pages took 30 seconds to load on a site, how likely would you be…
Crawling all SQL Server tables and columns for a specific value
We had a quick need to search all columns in every table during a data discovery exercise. This is by no means the most efficient, but it does work. It pulls 10,000 rows at a time from each table, and…