wp_fixit_guy

Place your website in any folder you care to ex. yoursite.com
Next, add the folder as a virtual website from within IIS manager.
Create whatever domain name you care to use and you’re all set.

You will need to have, php, MySQL, and URL re-write modules installed for the site to work properly…

I used to run all my sites from Windows Server 2008 R3 with obviously IIS installed… works fine…

Make that 8,493 IP addresses I have banned if anyone is interested…

They are hitting my one site hard and fast… getting over 2k ban’s and at least 400+ new IP’s every 24 hours…

I really wish somewhere someone knew what the other 81.5K IP addresses were… It would make my life easier… I am in the process of adding the IP’s I have to my firewall rules… (VPS)

If anyone is interested, I could post the now over 7.3K of IP addresses…

I am using “Ban” plugin along with a user log plugin… I do not use the “admin” or any variation thereof in any accounts and while using ban, once the IP is added to the list, their next visit lands the on the FBI’s Cyber Crimes Web Page… still doesn’t seem to discourage however, my thoughts are, let them try to hack the FBI’s page and maybe something will get done about this…

Anyone discover exactly what this “bot” is yet? That would be helpful as well…

I attempted to rename the wp-login.php file but, the results for logging out etc. became so convoluted, I just gave up… The registration script failed, the recover password script failed along with, the logout function would lead to an file not found page…

Pressing F12 on Internet Explorer is another valuable tool

And the morale to this story is, only edit your code via ftp as, you can quickly perform and “undo” on your ?.php page, and save it… you may experience a short outage but… I use a local server on my home equipment to “experiment” once it works locally then, try it on the server… the replace the theme is the quickest solution in your case… I concur with WP on this one…

Sorry for the delay in responding… In all honesty, your problem really lies within the statement WHERE post_status = ‘publish’ AND … How many posts does your blog have, and I would honestly refer you to the MySQL website along with, your themes ‘forum’ and see if anyone else has run into this problem…

The search from publish could be really slow on a large website and not having your MySQL tuned properly… I was working on one of my sites that used the somewhat the same statement to search for videos (believe it or not) through all my posts, almost four years with, extrapolate the appropriate data and send it to a “slider” in one of the sidebars… What I did was used the WordPress codex pages and rewrote the query to reflect ‘specific’ categories however, I see in your case it is ‘comments’… Is this by some chance a spam plug-in, would you have a link to the slow page? I am going to guess this code exists within your single.php or possibly a comments.php It would be nice to see the source code via a we page link (will do)…

Mind if I ask which theme you are using? Also, which provider are you using to host your site?