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

On 26/08/2021 08:39, Axel Schwenke wrote:
> 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...
> 
I didn't realize stucklehead was still alive.

-- 
  “A leader is best When people barely know he exists. Of a good leader, 
who talks little,When his work is done, his aim fulfilled,They will say, 
“We did this ourselves.”

― Lao Tzu, Tao Te Ching