François
François
DTDrizzle Team
Created by kge on 11/7/2024 in #help
I'm trying using $count, and it giving me fieldAlias missing. What should I do?
Shouldnt it be
historyCount: db.$count(history, eq(history.itemId, item.id))
historyCount: db.$count(history, eq(history.itemId, item.id))
?
6 replies
DTDrizzle Team
Created by François on 10/3/2024 in #help
Anyone also experiencing this issue?
Wish I would have enough time to further dig deeper into their code and actually fix it but life....
8 replies
DTDrizzle Team
Created by François on 10/3/2024 in #help
Anyone also experiencing this issue?
So the only fix I see now is downgrading the pg driver to 8.1.0 and hope for a fix on their site. I already opened an issue in their repo: https://github.com/brianc/node-postgres/issues/3325
8 replies
DTDrizzle Team
Created by François on 10/3/2024 in #help
Anyone also experiencing this issue?
Drizzle doesnt put together the query string itself. It calls a method of the pg driver passing a configuration object, that hols the query with the placeholders + an array with the values for the placeholders. The driver then puts together the query. Actuall its the query call I had in my benchmarking code, just with the different parameters. Comparing those two calls, the one with the direct query string and the config+parameters, results in the differences I see when using drizzle. The last version there was no difference was 8.1.0. 8.2.0 introduced a new parser which might be the problem. But still: Why am I the only one experienceing this issue 😄
8 replies
DTDrizzle Team
Created by François on 10/3/2024 in #help
Anyone also experiencing this issue?
Thats what I thought at first too but even starting the timer right before the execute call results in this slow performance. Digging deeper into the code I found out that the problem is the pg driver. From version 8.2.0 upwards the performance is as bad as it is in my example. Using 8.1.0 results in the same times. Its not surprising per se, bugs happen but I am suprised being the only one noticing this.
8 replies