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!
Пікірлер: 25
@JuliusGrybauskas9 ай бұрын
Always happy to see these videos!
@adventuresinnodeland7 ай бұрын
More to come!
@programmer-network9 ай бұрын
Thank you, Matteo. Will try to implement this in my programmer network Fastify API. Cheers man
@alexenax11094 ай бұрын
Great new module!
@timibolu9 ай бұрын
thanks mattteo for this
@khanhney9 ай бұрын
Nice video, Thank you so much
@adventuresinnodeland7 ай бұрын
Thank you too
@jurajzovinec9 ай бұрын
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"
@adventuresinnodeland9 ай бұрын
It’s in the roadmap and supported by async-cache-dedupe, we just need to wire it with Platformatic DB.
@alirezanqp9 ай бұрын
Thanks
@ted33099 ай бұрын
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.
@adventuresinnodeland9 ай бұрын
Good tip!
@ankit82686 ай бұрын
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-op4hh8le6u5 ай бұрын
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
@adventuresinnodeland5 ай бұрын
the latter is lower level and will deduplicate requests.
@user-op4hh8le6u5 ай бұрын
@@adventuresinnodeland I am not getting can you please describe I am bit confused and by the way you guys are doing great work
@adventuresinnodeland5 ай бұрын
@@user-op4hh8le6u use async-cache-dedupe
@minhhieple64839 ай бұрын
Thank you so much, One question, So we should use cache in every query to database, right ?
@adventuresinnodeland9 ай бұрын
Yes, at least for the one that fetched data.
@notaspectator9 ай бұрын
definitely not, choose wisely based on profiling and db stats ideally during stage testing
@cx12608 күн бұрын
wow
@admiralicic6 ай бұрын
Hit the Like in advance, thank you Matteo!
@codewithnws35449 ай бұрын
Can we have the link to the repo of that platformic db's github repo or access to the code !
@adventuresinnodeland9 ай бұрын
Here is the file I’m showing in the video github.com/platformatic/platformatic/blob/main/packages/sql-mapper/lib/cache.js
@tusharbarate49734 ай бұрын
Does this only work with promise.all? How about if I send same request out of promise.all? will that also return from cache ?