Re: Up to 50K inserts per second... smokin'!

On 26.08.2021 01:26, Jerry Stuckle wrote:

> Very understandable.  Each INSERT must be parsed and executed by the RDBMS.
> Parsing a text SQL statement and determining how to execute it is very time
> consuming, much more than actually doing the SQL statement.
> 
> That's why enterprise-level databases like IBM's DB2 have a means to
> preprocess static SQL statements and build access plans to do the work.  The
> resultant code doesn't actually submit the SQL statement but instead calls a
> function which executes the pre-built access plan.

That's a typical Stuckle post. MySQL introduced prepared statements in
version 4.1. That was somewhere around 2005. Whopping 16 years in the past.
Yet still he tries to sell it as a feature specific to enterprise RDBMS...