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 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 reference_id, [...]

[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

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 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 http://www.anandtech.