How to make your Node.js API 5x faster!

In this video I demostrate how to use the github.com/mcollina/async-cac... module to increase the req/s of Platformatic DB by 5x, while reducing the latency to 1/3. Amazing? You can implement it too!

[@JuliusGrybauskas]

Always happy to see these videos!

[@adventuresinnodeland]

More to come!

[@programmer-network]

Thank you, Matteo. Will try to implement this in my programmer network Fastify API.
Cheers man

[@timibolu]

thanks mattteo for this

[@alexenax1109]

Great new module!

[@khanhney]

Nice video, Thank you so much

[@adventuresinnodeland]

Thank you too

[@ankit8268]

But you don't have just one api in your web app, if there are 100 apis how many will overlap, moreover the input to the query also need to be same for this to work right, this can decrease the performance as well. Isn't it?

[@user-op4hh8le6u]

Hey Matteo Collina I have one question which package should we use for caching API. should we need to use async-cache-dedupe or fastify-caching ? because both packages ends up with cahcing data into redis or any in-mem cache

[@adventuresinnodeland]

the latter is lower level and will deduplicate requests.

[@user-op4hh8le6u]

@@adventuresinnodeland I am not getting can you please describe I am bit confused and by the way you guys are doing great work

[@adventuresinnodeland]

@@user-op4hh8le6u use async-cache-dedupe

[@alirezanqp]

Thanks

[@jurajzovinec]

Thanks for share this is nice video, still watching videos regarding evolving of Platformtic DB, can't wait to find a project allowing me to my hands on it :) Have you also thought of cache invalidation? Something like creating "relationships" between queries and mutations saying "Hey, if this mutation is running with this movie ID, clear query related object from cache"

[@adventuresinnodeland]

It’s in the roadmap and supported by async-cache-dedupe, we just need to wire it with Platformatic DB.

[@ted3309]

Good video! Also, can you point or say where you're looking at when you're using "htop" or other fancy tools, because It's hard to follow when you see a tool for the first time.

[@adventuresinnodeland]

Good tip!

[@codewithnws3544]

Can we have the link to the repo of that platformic db's github repo or access to the code !

[@adventuresinnodeland]

Here is the file I’m showing in the video github.com/platformatic/platformatic/blob/main/packages/sql-mapper/lib/cache.js

[@minhhieple6483]

Thank you so much, One question, So we should use cache in every query to database, right ?

[@adventuresinnodeland]

Yes, at least for the one that fetched data.

[@notaspectator]

definitely not, choose wisely based on profiling and db stats ideally during stage testing

[@cx1260]

wow

[@admiralicic]

Hit the Like in advance, thank you Matteo!

[@tusharbarate4973]

Does this only work with promise.all? How about if I send same request out of promise.all? will that also return from cache ?