search

mauricio / postgresql-async

Async, Netty based, database drivers for PostgreSQL and MySQL written in Scala
Apache License 2.0
1.43k stars 222 forks source link

Simple queries taking longer than 50 seconds when sendPreparedStatement is called #241

Open gabfssilva opened 6 years ago

gabfssilva commented 6 years ago

Probably the same issue: https://github.com/mauricio/postgresql-async/issues/212

I'm not being able to use postgresql-async in an existing PostgreSQL database since any query that I execute in a few tables is taking too long. I've been already using Slick with no issues whatsoever (not performance issues, at least) and I also tested with ScalikeJDBC. Also, if we execute sendQuery instead of sendPreparedStatement it works as expected.

Does anyone know what could be happening?

gabfssilva commented 6 years ago

Just discovered: the problem exists because all numeric scala types are being mapped to "Numeric". This PR corrects the issue: https://github.com/mauricio/postgresql-async/pull/231

oshai commented 5 years ago

I fixed/reverted this in jasync-sql(fork) 0.8.30: https://github.com/jasync-sql/jasync-sql/pull/16 . more details in the issue: https://github.com/jasync-sql/jasync-sql/issues/15