The website takes long to respond back. The issue is not just from my laptop, but from 10s of other laptops as well. The chrome devtools reports 8seconds as TTFB. Rest of the images, javascripts are all downloaded within a…
We have recently migrated a PHP web application to a different hosting. Along with that, the database was also successfully copied over to the new mysql server. The earlier version of database server was mysql5.6 and the new hosting has…
I am testing the performance of Node.js (ExpressJS/Fastify), Python (Flask) and Java (Spring Boot with webflux) with MongoDB. I hosted all these sample applications on the same server one after another so all services have the same environment. I used…
I'm trying to get prices from an external source and update my product prices in my woocomerce site in a daily basis. My problem is I have a ton of variations (150 products, each product has 10-15 variations, over 2000…
const score_schema = mongoose.Schema( { tester_id: { type: mongoose.Schema.Types.ObjectId, ref: "user", required: true, }, test_id: { type: mongoose.Schema.Types.ObjectId, ref: "test", required: true, }, score: { type: Number, required: true, }, }, { collection: `score`, timestamps: true, } ); query 1:…
I have the following query, which currently takes about 0.3s to load, causing a heavy load on my Wordpress site. SELECT SQL_CALC_FOUND_ROWS wp11_posts.ID FROM wp11_posts WHERE 1=1 AND ( wp11_posts.ID NOT IN ( SELECT object_id FROM wp11_term_relationships WHERE term_taxonomy_id IN…
We have a high traffic server running mysql. This database has run fine for years with no significant spikes in traffic or changes to the database but recently Mysql CPU consumption has spiked to a consistent 600%. We don't see…
I am developing an app which allows the user to search for books and then display it in the search results. For displaying the results, I am using a FlatList with 3 columns and displaying the book cover and some…
It is taking 15 seconds or so from the time the user submits their order for purchase, till they receive the thank you page on my WooCommerce site. WooCommerce 6.0.0 and Wordpress 5.8.3 The other pages on the site load…
I've been investing tons of hours searching and applying many different tests to try and see if I could optimize this query but I was not successfull so far. So this is based on a table with more than 6M…