Daily Archives: March 29, 2010

How To Use CSS "position"

Posted on March 29, 2010 by Masao 

position:static The default positioning for all elements is position:static, which means the element is not positioned and occurs where it normally would in the document. Normally you wouldn’t specify this unless you needed to override a positioning that had been … Continue reading →

Leave a comment

How To Use MySQL EXPLAIN

Posted on March 29, 2010 by Masao 

This stuff has helped improve many of my queries. The basics: Its bad whenever you have the second table in the explain returning more than 1 row. The driving table is first and all other tables joined to it should … Continue reading →

Leave a comment

Directed Acyclic Graph Information

Posted on March 29, 2010 by Masao 

SQL with Trees and Graphs http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html MySQL Stored Procedure of Dijkstra’s Algorithm http://www.artfulsoftware.com/infotree/queries.php?&bw=1059#766 http://www.codeproject.com/KB/database/Modeling_DAGs_on_SQL_DBs.aspx More on Nested Tree Model http://dev.mysql.com/tech-resources/articles/hierarchical-data.html http://articles.sitepoint.com/article/hierarchical-data-database/2

Posted in Data Structures | Leave a comment