In our system we are hashing passwords with the following method. public static string HashPassword(string password, byte[] salt) { if (salt == null) { throw new ArgumentNullException($...

I’m using GridDB Cloud (Free Tier) with Python to store time-series IoT data. My container currently has around 10 million rows, and it continues to grow daily. Schema: device_id STRING, created_at ...

I’m working with a hierarchical model structure in Django, where each level can represent a region, district, or village. The structure looks like this: class Location(models.Model): name = models....

I need to speed up a query that lists transactions from BillingInfo joined to site/customer tables. Users filter by CustomerName (first + last). Data volume: BillingInfo ≈ 3.1M rows CREATE TABLE [dbo]....

Let's create a table with 3000 rows create table tt(id int, txt text); insert into tt with recursive r(id) as (select 1 union all select id + 1 from r where id < 3e3) select id, concat('name', id) ...

In a table T with 20 million rows and a unique constraint on integer column uk, the following query induces SQL Server 2019 to perform a scan of all index entries instead of a single seek: select max(...

I am working in the backend of an application. One part of this application (like every application nowadays) is using AI for multiple things. The application's main purpose is building data warehouse ...

I'm learning PostgreSQL Clustering abilities and I would like to compare performance of the same query with table not clustered and with table clustered. I tried to generate 25 million user events and ...

I am working on one scenario where I have to check login flow of application for 10KTPM in minute. In my login flow exist- load the URL, Login and Home page load. In entire login flow we have 55 ...

We're using DSE 6.0.18 (Cassandra version 3.11) and our application is both read and write heavy. I have a situation where I need to fire N number of read queries for each API (by partition key) using ...

I'm using MongoDB Atlas and noticed a warning in the Performance Advisor and monitoring dashboard: "Query Targeting: Scanned Objects / Returned" has gone above 1000 From my understanding, ...

I need help evaluating the actual execution plan of an SQL Server View: https://www.brentozar.com/pastetheplan/?id=zAFOrTkUxr Context The above View is being called by Azure Data Factory to populate a ...

For the following query, what indexes should I create $match:{ "from_time": { "$gte": "2024-12-17T18:00:00.000Z" }, "to_time": ...

Some year ago, we switched from some self built leader election mechanism to spring integration leader election, both on MariaDB clusters, relying on duplicate key violation. We switched to spring ...

In MongoDB (version 8) I'm wondering about the most read-efficient way of storing a "sharing mechanism". I.e. the users can share items with other items within the same collection. When ...