Windows Cache Extension for PHP

Are you running/wanting to run your PHP app on IIS? Then check this out!

Windows Cache Extension for PHP is a PHP accelerator that is used to increase the speed of PHP applications running on Windows and Windows Server. Once the Windows Cache Extension for PHP is enabled and loaded by the PHP engine, PHP applications can take advantage of the functionality without any code modifications.

And what’s even better – you don’t have to configure it or start tweaking your code, it comes in Web P.I

So head over to Microsoft Web and download it today!

Check the size of your database, MySQL

Hello, folks, often times, we might want to know, how big a particular database size is. Here is a very simple, one-line query for you to check a database size on MySQL.

SELECT table_schema "[Data Base Name Which you want o know]", sum( data_length + index_length) / 1024 / 1024
"Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema ;

Enjoy querying, cheers.

Powered by MySQL:

What Are You Waiting for, Powershell Now!

Have you ever written any BAT file, Ruby, Python or any other before? Now, you got another alternative, which is Window Powershell!

It is a powerful tool for you to write build-process or pre-processing operations, etc. It is absolutely handy as Window Powershell is based on .Net. It supports XML, object, and so on.

Microsoft Windows PowerShell command line shell and scripting language helps IT Professionals achieve greater productivity. Using a new admin-focused scripting language, more than 130 standard command line tools, and consistent syntax and utilities, Windows PowerShell allows IT Professionals to more easily control system administration and accelerate automation. Windows PowerShell is easy to adopt, learn, and use, because it works with your existing IT infrastructure and existing script investments, and because it runs on Windows XP, Windows Vista, Windows Server 2003 and Windows Server ôLonghornö. Exchange Server 2007, System Center Operations Manager 2007, System Center Data Protection Manager V2, and System Center Virtual Machine Manager leverage Windows PowerShell to improve efficiency and productivity.

In short: PowerShell
exposes the power of .NET via a command line environment and scripting language
allows you to pipe objects from one command to another!
provides powerful supports of XML handling and regular expressions

So, what are you waiting for? Powershell now!

改善火狐性能

哈罗，好久不見，最近在赶工，所以對不起，没時间update blog.今天呢，要與火狐用戶分享一些非常有用的技巧。

有沒有試過使用火狐日子久了，性能慢慢的沒有之前那么的快呢？從火狐3.0開始，書簽，歷史都貯存到了SQL Lite數據庫中。那我們身為用戶，可以通過優化SQL Lite,來提升火狐的性能。

步驟如下：
轉到火狐的默認目錄：
~/.mozilla/firefox/xxxxxxxx..default/

若是针对单个的 SQLite 文件（如 places.sqlite）执行优化，则运行 sqlite3 places.sqlite vacuum。你也可以通过下列命令来对所有的 SQLite 文件执行优化：
for s in *.sqlite; { sqlite3 $s vacuum; }
注意：如果在你的 Linux 系统上找不到 sqlite3，则需要先行安装。另外，在执行优化时，你也要关闭 Firefox。

Enjoy!