When I copy a db table to another I want to start the rows at zero again.

It took me a little while to find the answer to this one, but it is very easy:

TRUNCATE TABLE xx;

That is the query statement I use within HeidiSQL to reset the id rows to zero while keeping the structure of the database intact.

I like comparing the different Coldfusion hosts that I use, I am always looking for fast loading pages. Here is one test I thought was interesting.

Using MySQL Administrator I compare the Connection Usage, Traffic and Number of Queries hitting the shared MySQL 5 boxes I am on.

These graphs are shown while my page load times are very good and it is 11:30pm at night.

Crystaltech:

Now this is from HostFolio.com:

To be honest I have no idea what I am looking at, but it appears that the HostFolio SQL server is being used less.

Some other time when the servers are very busy I will do more screen shots.

I have been looking for a new host besides Crystaltech.com for a backup location for my main rentvine.com site and I have tried two of them Hostfolio.com and HostMySite.com.

I have heard very good things about HostMySite over the years. They are a bit more expensive at $20 a month for shared Coldfusion hosting.

As for Hostfolio I have been using them for a couple of years for my smaller sites. They are around $8 a month for shared Coldfusion with its own IP address.

I was really surprised by the page load times between the expensive and cheaper hosting. HostMySite was all over the map with long page load times the first time I tested.

The time is in milliseconds and calculated by starting a Coldfusion timer at the top of each page and ending it at the footer and taking the difference in time. All test pages have one simple query to a MySQL DB and the queries are not cached.

The page load time from HostMySite on the first round of test at 10:30pm were bad, I contacted HostMySite and they said that the MySQL server I was on was having issues so they moved me. As you can see it got better, but still not a good at the much cheaper hosting.

I did talk to a tech at HostFolio and to be fair he said it was a new box and had about 200 sites on it so far, so how knows it could get worse in the future.

I am very impressed with Hostfolio tech support too. However I am not a big fan of their HELM software. I like Crystaltech’s control panel better.

I been doing a lot of work with DNS this past week. Two testing tricks I learned that are really helpful when moving DNS around on your web sites:

1. From the command prompt: ipconfig/flushdns
2. Then ping your domain or email like >ping mail.davecolorado.com to see what IP is returned so you can verify you are connecting to the right server.

I have several blogs on several different hosts and the PHP.ini file in the root of the directory works great everytime.

Just create a file called PHP.ini in the root of the site with the following two lines of code:

cgi.fix_pathinfo = 1
cgi.force_redirect = 0

This works on both Crystaltech and HostFolio.com