cargo check is really slow when running with postgres in docker-compose

[sindreij]

Hi. I am observing some weird behavior when using sqlx having a postgres-db in docker-compose.

When using a local postgres-database, cargo check takes around 2-3 seconds.
When using the database from docker-compose, cargo check takes 20 seconds.

When setting SQLX_OFFLINE to true, both are around 2 seconds.

Do anyone have any idea why this happens?

[abonander]

There shouldn't be a speed difference if it's hosted locally. The macros do tend to take forever if network latency is at all a factor. I'm not entirely sure why but I'd bet that Tokio and SQLx being compiled in debug mode has something to do with it.

Try the tip from the end of the following section in our README, see if it helps: https://github.com/launchbadge/sqlx/#compile-time-verification

[sindreij]

Thanks for the tip.

Is there any way to see if this is a network issue?

[abonander]

It depends entirely on how your system is set up.