Wednesday, August 27, 2008

How to use MySQL REPLACE function

update my_table SET `my_field` = replace(`my_field`, "old_text", "new_text")

Head over for more details to http://www.webmasterworld.com/forum10/8113.htm

Tuesday, August 19, 2008

Picking datatype for status field

Quite commonly in the applications you would need to use some kind of “status” field - status of order - “new”, “confirmed”, “in production”, “shipped” status of job, message etc. People use variety of ways to handle them often without giving enough thought to the choice which can cause problems later.For more details on this topic you find it on http://www.mysqlperformanceblog.com/2008/08/09/picking-datatype-for-status-feilds/

Wednesday, August 13, 2008

How to filter posted data easily in PHP?

Today i found one good article on how to filter the posted data in php.You can find the same in
http://roshanbh.com.np/2008/08/how-to-filter-posted-data-easily-in-php.html#more-217

Tuesday, August 12, 2008

ab - Apache HTTP server benchmarking tool

ab is a tool for benchmarking your Apache Hypertext Transfer Protocol (HTTP) server. It is designed to give you an impression of how your current Apache installation performs. This especially shows you how many requests per second your Apache installation is capable of serving.

You can find more details on how to use benchmark tool in below mentioned link.

Reference:

http://www.cyberciti.biz/tips/howto-performance-benchmarks-a-web-server.html