I'm trying to filter through millions of documents. Each document is about 7kB in size. For the moment, I'm filtering on a maximum of 8 (defined) fields, but more will be added later. Filters can be anything, like : "field":…
I have a given entity 'Student' with application based concurrency control defined on 'LastModified'. public class Student { public int Id { get; set; } public string Name { get; set; } = null!; public DateTimeOffset Created { get; set;…
I want MongoDB query to minus a day from existing date in a column and update the same. query to update a date like original date = '2024-12-24T18:30:32' updated date = '2024-12-23T18:30:32' and how to execute the query on terminal…
I have several queries along the lines of: INSERT INTO my_data_archive.my_table (id, FieldName, Value, Position, PageId) SELECT id, FieldName, Value, Position, PageId FROM my_data.my_table WHERE PageId IN (SELECT id FROM my_data.page WHERE PageTypeId BETWEEN 33 AND 36 AND Deleted IS…
I have a Azure Flexible Postgresql large partitioned table version 13 and I need to run count(*) from that table and compare with oracle performance. However I have some concerns after checking explain plan as below Explain plan already used…
How do I tell PostgreSQL this? :: Get me the highest-ranked result for every element in a group, ranked by these attributes that you can already find in an index, so you don't have to rank the entire table. See…
Let's say I have a function that retrieves data from API and the API returns array of objects. Each object has a lot of fields(20 or so). Now I want to use ONLY 'id' and 'name' of each object. Is…
I have a function in my javascript code that loops through an array and performs some time-taking actions on each item of the array. It works fine for now when the number of items is low in the array but…
Let's say I have an array of 10000 random integers. I want to while loop through it and add each number to a ul. The thing is, if I do something like this: const myArray = [/* 10000 totally random…
reactJS. have created multiple charts eg bar chart, pie chart. when these charts are placed in dashboard and if i sort bar chart, pie chart also re-rendered. this reduces the performance if the dashboard contains like 5-6 charts and all…