Re: [PERFORM] incredible surprise news from intel/micron right now...

2015-08-20 Thread Graeme B. Bell
On 28 Jul 2015, at 22:29, Graeme B. Bell graeme.b...@nibio.no wrote: Entering production, availability 2016 1000x faster than nand flash/ssd , eg dram-latency 10x denser than dram 1000x write endurance of nand Priced between flash and dram Manufactured by intel/micron Non-volatile

Re: [PERFORM] Most efficient way of querying M 'related' tables where N out of M may contain the key

2015-08-20 Thread David G. Johnston
On Thu, Aug 20, 2015 at 8:03 PM, Stephane Bailliez sbaill...@gmail.com wrote: Pretty bad subject description... but let me try to explain. I'm trying to figure out what would be the most efficient way to query data from multiple tables using a foreign key. ​SELECT [...] FROM (SELECT

[PERFORM] Most efficient way of querying M 'related' tables where N out of M may contain the key

2015-08-20 Thread Stephane Bailliez
Pretty bad subject description... but let me try to explain. I'm trying to figure out what would be the most efficient way to query data from multiple tables using a foreign key. Right now the table design is such that I have multiple tables that share some common information, and some specific