Skip to content
Announcing the Appwrite X MongoDB partnership
Start building
Back

email Login very slow (>10sec)

  • 0
  • Self Hosted
  • Accounts
  • Web
View on Discord
Gildas Quiniou
14 Dec, 2023, 15:53

gonna check

TL;DR
User is experiencing slow email login, suspecting password hashing as the cause. Support suggests trying Users API with MD5-hashed password. User tries and sees improvement. Support suggests upgrading to latest patch and creating backup beforehand. User asks about skipping versions during upgrade, support says it's possible. Support also suggests checking Appwrite and mariadb containers for logs. User provides version info.
D5
14 Dec, 2023, 15:54

And also, what's your Appwrite version?

Gildas Quiniou
14 Dec, 2023, 15:54

0.49 1min, 0.25 5min 0.17 15min

Gildas Quiniou
14 Dec, 2023, 15:55

1.4.7

Gildas Quiniou
14 Dec, 2023, 15:58

No but there are tons of logs. Which container should I look at? mariadb?

D5
14 Dec, 2023, 16:00

Appwrite if there's something related there

D5
14 Dec, 2023, 16:00

I would try upgrading to the latest patch, since it has bug fixes. This could be a bug. Remember performing a backup previously

Gildas Quiniou
14 Dec, 2023, 16:01

No, only errors regarding documents already existing which I asume to be when I add before update if existing in my app.

D5
14 Dec, 2023, 16:01

In fact one of the patches had an upgrade in the database framework so it could solve the issue

Gildas Quiniou
14 Dec, 2023, 16:02

OK, thx. Btw, I'm never sure about the upgrade process : can I skip right from 1.4.7 to any 1.4.x ? (x > 7)

D5
14 Dec, 2023, 16:03

You can go directly to the latest patch

D5
14 Dec, 2023, 16:03

Important to have a backup for in case something goes wrong

Gildas Quiniou
14 Dec, 2023, 16:03

sure 🙂

D5
14 Dec, 2023, 16:42

Tell me of upgrading solved the issue

Drake
14 Dec, 2023, 17:11

What are the specs on your server?

Gildas Quiniou
14 Dec, 2023, 18:57

6GB RAM + 4 GB Swap. 2 Cores of a Intel(R) Xeon(R) CPU E5-2690 v2 @ 3.00GHz A couple of users for the moment.

Gildas Quiniou
14 Dec, 2023, 18:58

Just upgraded to .13. Will take you updated asap. Thx.

Gildas Quiniou
15 Dec, 2023, 07:18

Hi, so far so good: 1,90s, way better even if it may seem a bit long just for a login (?) but the other requests times are ok too. Gonna upgrade my prod server and check if things are better too.

D5
15 Dec, 2023, 07:22

2s seems reasonable, but I find it a bit high too 🤔

D5
15 Dec, 2023, 08:15

How are you benchmarking it?

Meldiron
15 Dec, 2023, 09:04

Hey 👋 When working on some cloud features, I noticed similar behaviour for me. I suspect it might be passwod hashing causing this (we might have updated some configuration for our Cloud, but instead updated it it open-sourced version too).

Can you please try to use Users API and import user with MD5-hashed password? Lets see if that is faster

Meldiron
15 Dec, 2023, 09:18

Or anonymous session, it also skips password hashing

Gildas Quiniou
16 Dec, 2023, 11:39

In Chrome (Performance tab). Of course the network can be a bottleneck but the upgrade to .13 did the trick. Just upgraded my prod server and got the same result (~1.5sec / login). Thx.

Gildas Quiniou
16 Dec, 2023, 11:41

Hi Matej. Not sure what you mean: you want me to "import" a User? You mean "create" a new user with MD5-hashed mode?

Meldiron
17 Dec, 2023, 11:01

Hi 👋 Yes please. The idea is to create session without hashing it, and see if that makes it quicker.

Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more