From bf4fe4ffee8c708e8d39be2e23e67919c885a264 Mon Sep 17 00:00:00 2001 From: miles Date: Fri, 22 Mar 2013 00:45:01 +0000 Subject: [PATCH] discovered a bunch of failings in view Ontology, fixed them optimized the view Ontology queries so that it can now handle at least 100 times as many genes, probably more; it runs significantly faster and uses some joins in mysql to organize the data svn path=/; revision=439 --- Personnel/miles/Web Page/heatMap.php | 6 +- Personnel/miles/Web Page/viewOntology.php | 110 ++++++++-------------- 2 files changed, 43 insertions(+), 73 deletions(-) diff --git a/Personnel/miles/Web Page/heatMap.php b/Personnel/miles/Web Page/heatMap.php index 01e8dbf..6e7b480 100644 --- a/Personnel/miles/Web Page/heatMap.php +++ b/Personnel/miles/Web Page/heatMap.php @@ -231,7 +231,7 @@ function drawMap(init) { heatMap.fillRect(0,0,1500,500); startXCell = Math.floor(scrolledLeft/cellSize); startYCell = Math.floor(scrolledTop/cellSize); - for(var s=startXCell; (stopOffset)) { var index = Math.floor((y-topOffset)/cellSize) + Math.floor(scrolledTop/25); diff --git a/Personnel/miles/Web Page/viewOntology.php b/Personnel/miles/Web Page/viewOntology.php index 77fbbe8..b2b3d52 100644 --- a/Personnel/miles/Web Page/viewOntology.php +++ b/Personnel/miles/Web Page/viewOntology.php @@ -2,6 +2,8 @@

@@ -140,7 +110,7 @@ for(var i=0; i"; var genes = rawGenes.split(","); var geneCount = genes.length; @@ -217,12 +187,12 @@ function drawMap(init) { startXCell = Math.floor(scrolledLeft/cellSize); startYCell = Math.floor(scrolledTop/cellSize); - for(var s=startXCell; (s