MySQL Bugs: #102334: Inserting too slow EFC on .net core

Bug #102334	Inserting too slow EFC on .net core
Submitted:	21 Jan 2021 15:31	Modified:	24 Mar 2021 12:51
Reporter:	Sadam Skula	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	5.7.32-0ubuntu0.18.04.1	OS:	Ubuntu
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	#EFC

Description:
Inserting about 50.000 records into table with AI PK int is taking too much time.

We are inserting 500 by 500 records with transactions and that didn't helped too much.

We need more than 2 hours to insert 50.000 records with
framework - .net Core 3.1 
package - MySql.Data.EntityFrameworkCore --version 8.0.21
server - 5.7.32-0ubuntu0.18.04.1

This is critical bug and it cannot run into expected time to fit our production requirements.

How to repeat:
Create new project
Create database
Migrate db (db first)
Insert 50.000 records into table ( or less if you need faster response )

I had to add Category Connector / NET.

My first post and haven't seen that category.

Hello Sadam Skula,

Thank you for the bug report.
Please upgrade to latest version and report us back if the issue still exists in latest version along with a dummy project manifesting the problem. Thanks.

Regards,
Ashwini Patil

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".