Typo3 and Joomla in china

Query Performance Optimization

Jul 23, 2010 Database Leave a comment
Posted by admin

1.Slow Query Basics:Optimize Data Access

• Are you asking the database for data you do not need?
• Is MySQL examing too much data?(index solution)

2.Ways to restructure queries

• Complex queries Versus Many queries(few queries)
• Chopping up a query
• Join Decomposition(
  • When application joins may be more efficient
  • you cache and reuser a lot of data from earlier queries
  • you use multiple MyISAM tables
  • you distribute data across multiple severs
  • you replace joins with in() lists on larger tables
  • a  join refers to the same table multiple times
  • )

Notes on Storage Engine

Jul 23, 2010 Database Leave a comment
Posted by admin

1.The MyISAM Storage Engine

Table locks
No automated data recovery
No transactions
Only indexes are cached in memory
Compact storage

2.The memory storage Engine

Table locks
No dynamic rows(no BLOB  and TEXT , even VARCHAR)
Hash indexes are the default index type
No index statistics
Content is lost on restart

3.The InnoDB Storage Engine

Transactional
Foreign keys
Row-level locks
Multiversioning
Clustering by primary key
All indexes contain the primary key columns
Optimized caching
Unpached indexes
Slow [...]

Maven + spring + hibernate + flex

May 13, 2010 Projects Leave a comment
Posted by admin

These days i am learning new technology about java.As a web fan , i want to create a flash web with java called the top programming language.After  i downloaded  the pdf file of Beginning Java™ and Flex Migrating Java, Spring, Hibernate, and Maven Developers to Adobe Flex and red the description ,the author convince me [...]

Order Note

Mar 11, 2010 Database, PHP Leave a comment
Posted by admin

In php programming, we may notice that  if we sort  a group of datas by a string field storing numbers , maybe we can not get the correct order we want .For example:
image1.jpg,image2.jpg,image10.jpg,image20.jpg,
after using function sort(),得到：
image1.jpg,image10.jpg,image2.jpg,image20.jpg,
this may be not what we want, so we can use natsort() to fix it .
But in the database if [...]

Realurl configuration

Feb 22, 2010 PHP, Typo3 Leave a comment
Posted by admin

Sometimes we need friendly reading url  which realurl can support it powerfully.But when we built our own extension ,What should we pay attension to ?
At first .Note that make the link with plugin class method.
$this->pi_getPageLink($pageId,”,$param).
Here $pageId is the Id of page ,$param is like this
$param    = array(‘tx_bookonline_pi1[cID]‘=>$cat_uid);
Then we just need change the configuration file  of [...]

Typo3 step one

Feb 21, 2010 Projects Leave a comment
Posted by admin

Though i have been devodted to typo3 for just half and one year.But i must say thank you to typo3.It lets me know what is cms , how to build one site quickly , how  powerful typo3 is , what typo3 can do but others not.
As a cms , typo3 is complicated , at the [...]

Regular expression

Feb 21, 2010 PHP Leave a comment
Posted by admin