SQL EXPLAIN to analyse and improve SQL queries

Database SQL query is slow?

You can use MySQL's EXPLAIN to analyse the query, maybe the column of the WHERE clause needs to be indexed?

EXPLAIN SELECT tt.TicketNumber, tt.TimeIn,
               tt.ProjectReference, tt.EstimatedShipDate,
               tt.ActualShipDate, tt.ClientID,
               tt.ServiceCodes, tt.RepetitiveID,
               tt.CurrentProcess, tt.CurrentDPPerson,
               tt.RecordVolume, tt.DPPrinted, et.COUNTRY,
               et_1.COUNTRY, do.CUSTNAME
        FROM tt, et, et AS et_1, do
        WHERE tt.SubmitTime IS NULL
          AND tt.ActualPC = et.EMPLOYID
          AND tt.AssignedPC = et_1.EMPLOYID
          AND tt.ClientID = do.CUSTNMBR;

http://dev.mysql.com/doc/refman/5.0/en/explain-output.html


mysql> alter table MY_TABLE add INDEX IDX_F1_F2 (F1,F2);
mysql> SHOW INDEX FROM MY_TABLE;

http://devzone.advantagedatabase.com/dz/webhelp/advantage9.1/how_indexes_are_used_by_the_where_clause.htm

http://www.experts-exchange.com/Database/MySQL/A_1250-3-Ways-to-Speed-Up-MySQL.html 

data.table: Extension of data.frame for fast indexing, fast ordered joins, fast assignment, fast grouping and list columns

http://cran.r-project.org/web/packages/data.table/index.html

Enhanced data.frame. Fast indexing, fast ordered joins, fast assignment by reference, fast grouping and list columns in a short and flexible syntax. i and j may be expressions of column names directly, for faster development. Example: X[Y] is a fast join for large data.

http://datatable.r-forge.r-project.org/ 

Science enters $1,000 genome era

http://www.bbc.co.uk/news/science-environment-25751958

The ability to sequence a human genome for just $1,000 has arrived, a US genetic technology company has announced.

The HiSeq X Ten high throughput genetic sequencing machine was announced at the annual JP Morgan Healthcare Conference in San Francisco this week. The company said it had broken the "sound barrier" of human genomics.

The Toxins of William B. Coley and the Treatment of Bone and Soft-Tissue Sarcomas

http://www.ncbi.nlm.nih.gov/pmc/articles/PMC1888599/

In 1891, William B. Coley injected streptococcal organisms into a patient with inoperable cancer. He thought that the infection he produced would have the side effect of shrinking the malignant tumor. He was successful, and this was one of the first examples of immunotherapy. Over the next forty years, as head of the Bone Tumor Service at Memorial Hospital in New York, Coley injected more than 1000 cancer patients with bacteria or bacterial products. These products became known as Coley's Toxins. He and other doctors who used them reported excellent results, especially in bone and soft-tissue sarcomas.

Despite his reported good results, Coley's Toxins came under a great deal of criticism because many doctors did not believe his results. This criticism, along with the development of radiation therapy and chemotherapy, caused Coley's Toxins to gradually disappear from use. However, the modern science of immunology has shown that Coley's principles were correct and that some cancers are sensitive to an enhanced immune system. Because research is very active in this field, William B. Coley, a bone sarcoma surgeon, deserves the title "Father of Immunotherapy."

A Field Guide to Genomics Research

http://www.plosbiology.org/article/info%3Adoi%2F10.1371%2Fjournal.pbio.1001744

High-throughput technologies are enabling scientists to profile genomes, transcriptomes, proteomes, and metabolomes at an unprecedented scale[1]. All this “-omics” research (let's call it genomics for simplicity) is exciting—and game changing—but it's also fraught with dangers for the tenderfoot. Here, we've put together a brief “field guide” for those wishing to visit the genomics frontier, in which we use caricatures to illustrate various pitfalls that can beset those who inhabit this new territory. By documenting the behaviors of these common types, we hope to guide researchers in their quest to apply sound practices when designing genomics experiments and analyzing the resulting data. Many of the tendencies we have encountered are not specific to genomics research, but they are particularly acute in this field due to its interdisciplinary nature and the complexity of the data it produces.

The Farmer

“Let's harvest a bunch of data and design fancy tools, and then we'll figure out what to do with them.”

...

Scientists tell the truth…

http://themetapicture.com/scientists-tell-the-truth/

JavaScript Code quality tool

http://www.jslint.com/lint.html

JSLint is a JavaScript program that looks for problems in JavaScript programs. It is a code quality tool.

When C was a young programming language, there were several common programming errors that were not caught by the primitive compilers, so an accessory program called lint was developed that would scan a source file, looking for problems.

As the language matured, the definition of the language was strengthened to eliminate some insecurities, and compilers got better at issuing warnings.lint is no longer needed.

IBM ThinkPad Laptop Keyboard not working

Problem: When you type "p" a "/" shows up, "U" becomes "4", etc.

Fix: Fn + ScrLk

http://en.kioskea.net/forum/affich-101274-laptop-keyboard-problem

What is aging?

https://www.youtube.com/watch?feature=player_embedded&v=jc4yK0zZ-cQ

Happiness

It’s not goal attainment, but the process of striving after goals – that is, growth – that brings happiness. -- Happier at Home

Comedy is hard

Dying is easy; comedy is hard

Exceed

Ah, but a man’s reach should exceed his grasp, or what’s a heaven for? -- Robert Browning

Making better inferences from statistical graphics Edward Tufte

http://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=0003wa#!

http://pps.sagepub.com/content/7/6/645.full

Why Science Is Not Necessarily Self-Correcting

The ability to self-correct is considered a hallmark of science. However, self-correction does not always happen to scientific evidence by default