Solomon Bier SolomonBier

Introduction

:q        close
:w        write/saves
:wa[!]    write/save all windows [force]
:wq       write/save and close

	#!/usr/bin/env python
	# marc-w.com
	# Built and tested on Django 1.5

	class BulkInsertManager(models.Manager):

	def _bulk_insert_ignore(self, create_fields, values, print_sql=False):
	'''
	Bulk insert/ignore
	@param create_fields : list, required, fields for the insert field declaration

	Latency Comparison Numbers (~2012)
	----------------------------------
	L1 cache reference 0.5 ns
	Branch mispredict 5 ns
	L2 cache reference 7 ns 14x L1 cache
	Mutex lock/unlock 25 ns
	Main memory reference 100 ns 20x L2 cache, 200x L1 cache
	Compress 1K bytes with Zippy 3,000 ns 3 us
	Send 1K bytes over 1 Gbps network 10,000 ns 10 us
	Read 4K randomly from SSD* 150,000 ns 150 us ~1GB/sec SSD