Skip to content

Instantly share code, notes, and snippets.

@meatcar

meatcar/gist:ae11509df7564dc2c16d

Created September 11, 2014 17:55
Show Gist options
  • Save meatcar/ae11509df7564dc2c16d to your computer and use it in GitHub Desktop.
Save meatcar/ae11509df7564dc2c16d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.md

Infobright ICE vs IEE

Materials

Run on SSD, 16GB RAM, Intel i7-4770k CPU

Imports are done on an empty database.

largedb contains 87 million pre-imported variants.

Results

Task ICE (s) IEE (s) Bottleneck
Search "Mode of Inheritance" in largedb 10 9 Database
----------------------------------------- --------- --------- -----------
Loading "Mode of Inheritance" in largedb 98 25 Database
----------------------------------------- --------- --------- -----------
Uploading 4MB exon VCF 320 Parsing + Annotating (regex, string functions)
----------------------------------------- --------- --------- -----------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment