perf: remove naming series from log-like doctypes

[ankush]

Removed naming series from:

• webhook request log
• access log

These are unnecessary and make operations sequential because of the naming series lock.

Example: 20+ parallel workers effectively operating sequentially because they are all waiting for lock for incrementing series counter on a log table 💸

PS: If you want it on your site, it's easy to add it back from "Customize form" having this by default isn't required.

[codecov]

Codecov Report

Merging #16823 (aac4df4) into develop (ee40bda) will decrease coverage by 1.79%.
The diff coverage is n/a.

@@             Coverage Diff             @@
##           develop   #16823      +/-   ##
===========================================
- Coverage    58.09%   56.30%   -1.80%     
===========================================
  Files          765      765              
  Lines        68616    68616              
  Branches      5956     5956              
===========================================
- Hits         39863    38632    -1231     
- Misses       25154    26385    +1231     
  Partials      3599     3599              

Flag	Coverage Δ
server	60.81% <ø> (-2.84%)	⬇️

Flags with carried forward coverage won't be shown. Click here to find out more.

[phot0n]

LGTM 👍

PS:

1. we could maybe even convert the engine to myiasm?
2. maybe we can add webhook request log to log_types? - it can then be considered for autoincrement automatically for new sites 😬

frappe/frappe/model/__init__.py

Lines 117 to 132 in ee40bda

	log_types = (
	"Version",
	"Error Log",
	"Scheduled Job Log",
	"Event Sync Log",
	"Event Update Log",
	"Access Log",
	"View Log",
	"Activity Log",
	"Energy Point Log",
	"Notification Log",
	"Email Queue",
	"DocShare",
	"Document Follow",
	"Console Log",
	)

[ankush]

we could maybe even convert the engine to myiasm

Patching existing data is quite painful. Also equivalent doesn't exist for PG.