Background
With the aquisition of a new machine to host the astro-server we thought it would be wise to test new ways of arranging the event-data for faster querying.
We decided on two major tests:
- Indexing data based on a spatial tesselation using Hierarchical Triangular Mesh (new) vs (old) indexing by Ra, Dec
- Comparing performance of Oracle (new) vs MySql
HTM Indexing
Gorey Details: http://skyserver.org/htm/HtmPrimer/tut_htm.html
We've settled on a degree of 6 which gives 2^15^ regions running from 2^15^ through 2^16^-1.
Overview
Content Tools