Re: [PERFORM] Storing large documents - one table or partition by doc?

2016-09-24 Thread Jim Nasby
On 9/24/16 6:33 AM, Dev Nop wrote: This means that the applications are sensitive to the size of ids. A previous incarnation used GUIDs which was a brutal overhead for large documents. If GUIDs *stored in a binary format* were too large, then you won't be terribly happy with the 24 byte per-ro

Re: [PERFORM] Storing large documents - one table or partition by doc?

2016-09-24 Thread Dev Nop
Thank you Mike & Jim for your responses. > Are there other issues/requirements that are creating other performance concerns > that aren’t obvious in your initial post Yes, there are a few things: *1. Full document queries really are necessary* > it’s too much data to show on a web page, for ins