Commentary on Beijing’s South China Sea Claims Rejected by Hague Tribunal

International tribunals and organizations have ZERO power these days especially over super power nations like China. China has become far too powerful to confront with military enforcement of the findings.


Most corporations around the world sold their soul to China years ago in the name of profits. Nearly every item you buy, including those American flags we all were waving on July 4th, come from China solely to keep prices down and profits up.

If the world wants China to abide by a ruling against their egregious and aggressive behavior in the South China Sea it needs to start with economic ramifications. Not federal trade restrictions alone, but American corporations pulling manufacturing contracts from China. Preferably back to the USA but anywhere but China. It will be a long road, but if it doesn’t change China will soon be the world’s largest and most powerful Super Nation. The most powerful countries make the rules.

Beijing’s South China Sea Claims Rejected by Hague Tribunal
The New York Times

The panel delivered a sweeping rebuke on Tuesday of China’s behavior, deciding that its expansive claim to sovereignty over the waters had no legal basis. Read the full story

Shared from Apple News

UK has fastest mobile internet while US lags behind, says report

This is not a surprise to most Americans. US ISPs and mobile providers focus on profits over service. America has some of the worst Internet services in the world. Literally.

If you think America is the world leader in technology and innovation, think again. Many of the largest and most disruptive new companies are from Europe these days.

Now You Know Everything About Music Publishing… – Digital Music News

An article that does a great job explaining the intricacies of music licensing, copyright, royalties, and publishing. It is a complex system with a lot of moving parts. IMO this complexity makes it difficult for artists to control their own product. In turn this has created and industry where the source of the product , the artists, are easily taken advantage of. Everyone done the distribution chain has their hand out, leaving nothing for the artists.

Performance Issues? Check Your Indexes

Any of the tech geeks that have worked for me in the past have heard me say it a million times.

“Check your indexes , people!”

It is the single-most overlooked issue that often yields the biggest performance gains on any SQL driven data system like WordPress, for example.

I cannot tell you how many times a junior coder or systems person has walked into my office and asked me to help them resolve an application performance problem.   The first thing I ask them is if the problem is data related.  The very next question is “have you checked your indexes?”.  More times than I can count  they find an improper or missing index.  Using SQL tools like ‘explain’ and building a proper index for the query that is causing problems can yield big performance gains with little effort.

Today I ran into a performance problem using my WordPress Dev Kit plugin that serves plugin updates to my WordPress plugin customers.   The dashboard on the sales site was horrendously slow.   The admin panel would take up to a full minute to load.    Building the right index on my data table brought that time down to less than 3 seconds.

Finding The Problem

I started by installing and enabling Query Monitor on my site.   This allowed me to see what was taking so long to execute.    The first report, a red herring, was the 18,000 entries from the wp_options table that was being loaded.

Turns out there were 15,000+ entries for _site_transient_brute_loginable , all of which were set to autoload.  That means WordPress was loading all 15,000 outdated and obsolete Brute Protect transients.

Query Monitor Output

Query Monitor Output

After deleting those 15,000 entries, Query Monitor brought me to the real culprit.  There were 4 database queries that were running slowly.  ONE of the queries was coming from my WPDK plugin.    It was only selecting 20 records , the 20 most recent entries, from a table with only a few data points.    However that table has 800,000+ rows and grows by a few thousand on a daily basis.

Fixing The Problem

The problem is that even though I was only asking for 20 records the “select the newest” was the problem.   MySQL had to read the ENTIRE database to find which 20 records were the newest.   Adding a simple index to the table fixed that issue.   Building an index on the lastupdated field allows the order by lastupdated DESC clause to utilize the index and read only 20 nodes from the index to fetch the record.    It is MUCH faster.  As in 57 seconds faster on a 60 second query.

MySQL Command Line Create Index

MySQL Command Line Create Index



Billboard: Samsung, Google and Spotify Have Considered Buying Tidal: Report

Samsung, Google and Spotify Have Considered Buying Tidal: Report

“Samsung is re-engaging; they are working on something really big, and they’re keeping it very quiet in case it leaks,” reports the Post. Read the full story

Shared from Apple News

%d bloggers like this: