On Tue, Feb 9, 2016 at 4:09 PM, Dan Langille wrote:
> I have a wee database server which regularly tries to insert 1.5 million or
> even 15 million new rows into a 400 million row table. Sometimes these
> inserts take hours.
>
> The actual query to produces the join is fast. It's the insert whic
I have a wee database server which regularly tries to insert 1.5 million or
even 15 million new rows into a 400 million row table. Sometimes these inserts
take hours.
The actual query to produces the join is fast. It's the insert which is slow.
INSERT INTO File (FileIndex, JobId, PathId, File