Community Posts

A Static Website I had a great conversation with a friend from work about doing some devblog stuff. Till then, I hadn’t heard of generating static web pages, especially not with some content generator. I was intrigued to say the least. Here we are, writing a devblog and utilizing some cool stuff. The only problems I have with this plan: The phrase devblog is not my favorite, and I’m not great at writing. Read more → about Setting up a static site in S3

Inspecting OpenEdge metadata with SQL OpenEdge’s virtual system tables (VSTs) provide excellent statistics that help in database development and maintenance. This article shows a few SQL statements that help reveal information about the database. SQL to query metadata Show all VST tables that contain metadata. Find columns in a table Show all the indexes on a table Assuming UPDATE TABLE STATISTICS AND INDEX STATISTICS AND ALL COLUMN has been run, get # of records for each table. Read more → about Inspecting OpenEdge metadata with SQL

Viewing query plan with SQL in OpenEdge It is important to review query plan produced by the database and improve queries from time to time. OpenEdge generates query plan for the queries you write. This article shows how to view query plan in OpenEdge. View query plan Let’s say the query below is taking a long time: When this query is executed, _sql_plan table is populated with information about how the query was processed. Read more → about Viewing query plan with SQL in OpenEdge

This week at work I was faced with a bug that manifested as Windows XP clients being slower to access parts of a web interface than Windows 7 or 10. This was strange because in Wireshark the requests looked basically the same. It turned out that the embedded system hosting the web interface was rejecting Ethernet frames larger than 1500 bytes. This was most likely because of a misinterpretation of the MTU as referring to the frame size (at layer 2) instead of the payload size (at layer 3). Read more → about Windows XP and Slow HTTP Requests