I have a query like select C.customerId, C.firstName, C.LastName, R.IsActive from Customer as C Inner join Rider as R ON R.customerId = C.customerid where R.rideid = 'xyz' and R.rideareacode = 'abc' and R.isActive = 1 This is taking too much…
I have a PostgreSQL table named users which contains between 20 to 30 million records. The table has the following columns: id, tenant_id, name, company, location, and description. I need to perform generic search queries on this table with various…
we load angular component on scroll for better page performance but these component content not crawled by google bot. we have implemented angular ssr & prerendering. we are using scroll event @HostListener('window:scroll', ['$event'])
I need to index a Postgres column that consists of mostly NULL values. I don't want the NULL values to be stored in the index (to make the index smaller, and to speed up row insertion). However, adding a partial…
I have one index created { v: 2, key: { xxxx: 1 }, name: 'xxxx', background: true }, But I have a lot of long queries with "sort": { "xxx": -1 }, Will creating an additional index with -1 help…
I am given a matrix with dimensions dim = nxmx4. I would like to flatten this matrix to a new 1-dimensional matrix with length l = n*m*4 using 3 nested for-loops. for (let x = 0; x < n; x++)…
In Postgres 16.2 I've a table Product with extra index: CREATE TABLE Product (id SERIAL , name: text, companyId: number, PRIMARY KEY (id)); CREATE INDEX product_company_id ON Product (companyId); The table has about 12M rows. When I search for a…
We are trying to optimize a query to a partitioned table, the query looks something like this: SELECT col1, col2 FROM partitioned_table WHERE profile_id = '00000000-0000-0000-0000-000000000000' AND product_id = 'product_a' ORDER BY created_at DESC LIMIT 500; Parent/partitioned table definition: CREATE…
I have a table with ~35M rows, and trying to find "processed" records to remove from time to time. There are 14 valid statuses, and 10 of them are processed. id uuid default uuid_generate_v4() not null primary key, fk_id uuid…
In MySQL 5.7.25 and MariaDB 10.6.15, using InnoDB by default to create below table create table t1( id serial, employee_id int not null, name varchar(20), status tinyint, created_at datetime(3) not null, updated_at datetime(3) not null, event CHAR not null, primary…