I have a table, let's say, users that has a one to many relationship to another table called, say, users_attributes. The users_attributes table is a simple key-value type table with a foreign key column to the users table. Something like…
navigation menu import { v4 as uuid } from "uuid"; import Link from "next/link"; import { getAllCategories } from "src/utils/api"; export default async function NavMenu() { const {data: categories} = await getAllCategories(); return ( <div className="NavMenu"> <ul className="NavMenu__categories"> {categories?.map((cat) =>…
const p1 = new Promise((resolve,reject) => { setTimeout(()=>{ resolve("xxx"); }, 5000) }); const p2 = new Promise((resolve,reject) => { setTimeout(()=>{ resolve("xx"); }, 10000) }); async function he() { console.log("start"); const s1 = await p1; console.log("Rome"); const s2 = await p2;…
Using Vue3 I have the following object $products [{ "id": 1, "item": "Product 1", "productcategories": [{ "id": 300, "title": "Category300" }, { "id": 301, "title": "Category301" }], }, { "id": 2, "item": "Product 2", "productcategories": [{ "id": 200, "title": "Category200"…
Our IP address ranges table has ~2.8 million records, of the following structure: { start_ip: integer, // IPv4 converted to int32 end_ip: integer, // IPv4 converted to int32 country_code: string, country: string, region: string, city: string } There is a…
Which one is better to use in general? dynamic import with import() statement or script loading function? they both make network requests, so which one is more performant? Or maybe webpack's built-in dynamic import() is the best one to use?…
I have an old legacy service for benchmarking a load produced by html5-pages to the users hardware. Here is a high-level idea: we want to be sure that some specific web-page will not freeze users browser and laptop with heavy…
I'm experiencing significant performance issues when searching for products by name or SKU in the WordPress WooCommerce admin. With around 40k products, the search takes between 16 to 50 seconds, which is quite slow. Furthermore, sometimes this delay results in…
I've built many queries on my PostgreSQL database, but some of them take a very long time to load, and I'm having trouble understanding why. Especially the one below, which can return a lot of information but uses very simple…
Trying to debug a slow query: SELECT IFNULL(SUM(bt.transactionQuantity * bpd.unitPrice), 0) FROM batchTransaction bt LEFT JOIN batch b ON b.id = bt.batchId LEFT JOIN batchPricingDetails bpd ON bpd.id = b.batchPricingDetailsId WHERE (bt.productId, bt.dateCreated) IN ( SELECT productId, MAX(dateCreated) FROM batchTransaction…