Message 164282 - Python tracker

Message164282

Author	pxd
Recipients	amaury.forgeotdarc, arigo, ghaering, jcea, pitrou, pxd
Date	2012-06-28.17:36:09
SpamBayes Score	-1.0
Marked as misclassified	Yes
Message-id	<1340904970.5.0.248320618591.issue15108@psf.upfronthosting.co.za>
In-reply-to

Content
Wondering the same thing myself, and yes sqlite3_column_type() by itself doesn't seem expensive. I assumed in general it was to allow more responsiveness for apps with huge number of columns (i.e. large tuple size). But we have about 20-25 columns and so I was going to try removing it and seeing the results. In any case, it seems, fewer GIL acquire/releases will help with throughput. Are there any guidelines on when GIL should be released? Re PyTuple_SET_ITEM...yes that's also a possibility but it would then hide genuine bugs.

Content

Wondering the same thing myself, and yes sqlite3_column_type() by itself doesn't seem expensive.   I assumed in general it was to allow more responsiveness for apps with huge number of columns (i.e. large tuple size).  But we have about 20-25 columns and so I was going to try removing it and seeing the
results. In any case, it seems, fewer GIL acquire/releases  will help with throughput.  
Are there any guidelines on when GIL should be released?

Re PyTuple_SET_ITEM...yes that's also a possibility but it would then hide genuine bugs.

History
Date	User	Action	Args
2012-06-28 17:36:10	pxd	set	recipients: + pxd, arigo, jcea, ghaering, amaury.forgeotdarc, pitrou
2012-06-28 17:36:10	pxd	set	messageid: <1340904970.5.0.248320618591.issue15108@psf.upfronthosting.co.za>
2012-06-28 17:36:09	pxd	link	issue15108 messages
2012-06-28 17:36:09	pxd	create