一种精神 | 冷雨飞竹

Archive for the ‘LAMP’ Category

wordpress使用了时间长了，很多文章改过好多次，留下了一片的修订版本数据，所以得清理一下，假定数据前缀 wp_ ，使用sql语句：

DELETE a,b,c FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

这个是解释性的文章 并不含如何安装

http://windows.php.net/download/ windows中使用的php文件是在这里下载，但是非常不幸，解释文章在左侧边下面不起眼的位置。

Which version do I choose?

If you are using PHP with Apache 1 or Apache2 from apache.org you need to use the VC6 versions of PHP
If you are using PHP with IIS you should use the VC9 versions of PHP
VC6 Versions are compiled with the legacy Visual Studio 6 compiler
VC9 Versions are compiled with the Visual Studio 2008 compiler and have improvements in performance and stability. The VC9 versions require you to have the Microsoft 2008 C++ Runtime (x86) or the Microsoft 2008 C++ Runtime (x64) installed
Do NOT use VC9 version with apache.org binaries

诶诶，郁闷了吧
Thread Safe是线程安全，一般apache模块、iis的ISAPI需要使用
Non Thread Safe是无线程安全的，因为php-cgi不需要。
VC6和VC9,vc6是给apache用的,vc9是给IIS用的。VC9需要安装c++2008运行库。

所以 嘿嘿 明白了哇 另外 iis7 现在对php支持的非常好，还自带fastcgi，效率非常高。