Houston Clubs web design and life

How to find Slow MySQL queries and Optimize your Tables

Feb 12, 2008 by Paul White


After you see good growth in your site for months, suddenly things start to get slow.  If your site is driven by a MySQL database, this is most likely the problem.  Bandwidth, Transfer, or even your home internet connection is not the problem.  The problem is you have some slow queries driving your site.  When I say slow we are talking computer terms.  Slow could be a fast as 15 ms.  One slow query isn't the problem its when you get hundreds of slow queries  made by hundreds of users at the same time that it becomes a problem.  MySQL is very powerful but only if you create the right indexes.  I recently applied these techniques on one of my websites.  Here is the step by step guide ( by me ) on how to optimize your MySQL tables. If your ASP.NET site is dragging this can make it 10 times faster.

Stop Spam in SmarterMail with RBL SBL and BL

Feb 8, 2008 by Paul White


Once you get a VPS box from HostMySite and you are running your own mail server, the first thing you will notice is how much spam is getting through.  This is because there are not advanced spam filters setup when Smartermail was installed on your VPS.  So its time to take things into your own hands.  Here is the list of RBL SBL BL servers I use to block 99% of all spam. It works so well I was able to cancel my account with postini.

Sony PS3 cures Cancer

Feb 6, 2008 by Paul White


Aside from making a dent in the productivity of millions. The PS3 is now helping to do medical research. A program called Folding at Home distributed by Standford University is now on your PS3 after you do the lastest system update. I have left my PS3 on for several days now, to help do my part.

Time for blog 2.0

Feb 2, 2008 by Paul White

The SEO world was rocked in January when google changed the way it runs SERPS. They are basically cracking down on how people load keywords into their titles, and pages to increase their rank. I was going to recode my blog engine anyway to make it more efficient. Thanks to google my blog 2.0 engine is now a priority on my todo list.

2008 Florida Primary Analysis

Jan 29, 2008 by Paul White

I have taken notice of a few things leading up to the Florida Primary.

What is the Fair Tax?

Jan 26, 2008 by Paul White

Huckabee brought up this issue in his campaign. After some further research, I found that it would be a national Sales Tax. The rate would be around 23%. I thought this out, and figured out the pros and cons.

Cadillac has Lamborghini Design Skills

Jan 21, 2008 by Paul White


Found this picture browsing the internet. It looks more like a Lamborghini than a cadillac. Shows they have some very talented designers over at GM. Why this thing isn't making it to market I have no idea. Rumor says it is to be the replacement for the XLR. If the stats are correct, this will compete against the Ferrari, and Lamborghinis, but of course still won't touch the Venom.  It would be good if gm was to bring this into production.  The current XLR is a joke,  as its nothing more than a corvette with different body panels.

Goener Nebraska

Dec 23, 2007 by Paul White

Over Christmas we visited family out in Goener Nebraska. Kind of neat little town. Lots of old buildings and a big Nebraska Sky.

Microprocessor Performance Explained

Nov 16, 2007 by Paul White

It used to be you could judge a Chip by its clock speed. It was very easy for just about any consumer to see that a high clock speed meant faster performance. But in today's world of hyperthreading, duel core, quad core, and manufactures stepping away from this logically simple way of judging performance, you almost need a computer science degree to know what is fast and what is not.

Iniquity Houston NightClub

Nov 12, 2007 by Paul White

Iniquity Houston gave my client a sneak preview to its layout. You have to checkout the photos of this place.