[server] Improve massive deletion of entities
sqlserver is limited on the "IN" array size and produce an error "The query
processor ran out of internal resources and could not produce a query plan".
The exact limitation is unclear but can occur with > 10000 item in the array.
See https://support.microsoft.com/en-us/kb/288095
Now we process the deletion by batch of 10000, some quick benchmarks show that
there is no performance impact:
delete_in(50000): 46.765182972
delete_in_batch(50000): 46.3242430687
delete_in(100000): 62.2969429493
delete_in_batch(100000): 61.8402349949
[MASTER]
load-plugins=cubicweb.pylintext
ignore=__pkginfo__
[MESSAGES CONTROL]
disable = too-many-ancestors,too-many-instance-attributes,too-many-public-methods,
too-few-public-methods,too-many-arguments,import-error
[BASIC]
function-rgx = [a-z_][a-z0-9_]{2,35}$
good-names=w,_
[TYPECHECK]
generated-members=debug,info,notice,warning,error,critical,exception
[CLASSES]
exclude-protected=_cw,_cnx,
# namedtuple public API.
_asdict,_fields,_replace,_source,_make
[FORMAT]
max-line-length=100
max-module-lines=2000