[Bug]: importing numerous [851] contacts from a vcard file is EXTRAORDINAILY slow.

[etyrnal]

⚠️ This issue respects the following points: ⚠️

• [X] This is a bug, not a question or a configuration/webserver/proxy issue.
• [X] This issue is not already reported on Github (I've searched it).
• [X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• [X] Nextcloud Server is running on 64bit capable CPU, PHP and OS.
• [X] I agree to follow Nextcloud's Code of Conduct.

Bug description

[Bug]: importing numerous [851] contacts from a vcard file is EXTREMELY slow.

When i import a VCARD into the contacts app, it's EXTREMELY slow compared to ANY other modern technological platform i've used that can import multiple contacts from a single VCARD file.

I've noticed this every time i've set up a new Nc instance on any version including the latest.

I'm talking about the process taking more than a half hour, It takes less time to install and set up a new instance of Nc than it does to import a VCARD into contacts with 851 contacts. This is NOT right.

Steps to reproduce

1. find a vcard file containing 800 plus contacts with multiple phone numbers, addresses, email addresses, etc. around 266KB.
2. Import that VCARD into the contacts app.
3. Wait an EXTRAORDINARLITY long amount of time.

Expected behavior

The expected behavior for a modern CPU to import 851 text-based records into a database is that it would take a brief INSTANT.

Installation method

Community SNAP package

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.1

Web server

No response

Database engine version

No response

Is this bug present after an update or on a fresh install?

Fresh Nextcloud Server install

Are you using the Nextcloud Server Encryption module?

No response

What user-backends are you using?

• [X] Default user-backend (database)
• [ ] LDAP/ Active Directory
• [ ] SSO - SAML
• [ ] Other

Configuration report

fresh base server install from snap with Contacts app installed.

List of activated Apps

base fresh install with recommended apps including Contacts

Nextcloud Signing status

No response

Nextcloud Logs

No response

Additional info

No response

[Uatschitchun]

Having the problem with importing only ~70 contacts, which results in 504 Gateway timeouts of my server!

[cazinc]

Seeing the same: importing around 400 contacts seems to have taken days (literally), CPU utilisation went to 100% and the server stopped responding for quite a while. Doubtless other factors involved (e.g. not sure what Contacts.app on my Mac is doing with regard to importing the contacts) but effectively killing the server and file syncing for a time isn't good.