CNN.com- Police: Trayvon Martin's death 'ultimately avoidable'
- Man questioned in highway killings
- Flesh-eating infections: Scores per year
- Travolta accuser hires Gloria Allred
- Court upholds Mississippi pardons
- Facebook IPO: Internet glee, skepticism
- Do voters want moderates out of D.C.?
- Now it's the jury's turn in Edwards trial
- Breyer's D.C. home hit by burglary
- Opinion: Dimon's $23M isn't the problem
- BBC
- VIDEO: Help offered on bringing up baby
- China jails smuggler Lai for life
- Airport starts search for new MD
- Dementia patient 'had 106 carers'
- Quarter of buses have problems
- 'Escalator tore off my big toe'
- Sex offenders get police cautions
- VIDEO: Malawi babies who are fighting to grow
- VIDEO: UK prepares for Olympic flame arrival
- VIDEO: G8 leaders to meet at Camp David
- AL JAZEERA ENGLISH (AJE)
- 'Disco queen' Donna Summer dies at 63
- Facebook to go public in $104bn flotation
- Tunisia-uprising injured sew lips in protest
- DR Congo troops shell rebel bases
- UN chief blames al-Qaeda for Syria bombings
- China jails fugitive smuggler for life
- Mladic trial postponed over 'errors'
- Fitch downgrades Greece on euro exit fears
- New French cabinet takes pay cut
- Obama unveils 'new chapter' in Myanmar ties
Monthly Archives: March 2010
How To Use CSS "position"
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
How To Use MySQL EXPLAIN
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
Directed Acyclic Graph Information
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
How To Speed Up Firefox
If your Firefox is running slow, try this to make it go faster. These tips should only be used by broadband users. Go to “about:config” Search for “pipe” Set the following values: network.http.pipelining = true network.http.proxy.pipelining = true network.http.pipelining.maxrequests = … Continue reading
SQL: ORDER BY With Zeroes Last
How to sort values from lowest to highest, but leaving the zeroes last: SELECT foo FROM bar order by foo = 0, foo ASC
How To Fix "The total number of locks exceeds the lock table size"
This usually happens when you’re doing massive queries on InnoDB tables: ERROR 1206 (HY000): The total number of locks exceeds the lock table size In /etc/my.cnf, do something like this: innodb_buffer_pool_size=524288000 By default, MySQL sets innodb_buffer_pool_size to 8MB. 500 megabytes … Continue reading