All Questions
Tagged with performance database
2,518
questions
0
votes
1
answer
42
views
Efficiency of Redis compared to relational DBs in Python
My data contains of 6mln rows with such columns:
'primary_key', 'timestamp', 'temperature_value','sensor_id', 'sensor_status'
e.g.
1, 2023-01-01 00:00:00.0, 20.28, 1, GOOD
The data was written to ...
0
votes
0
answers
6
views
Scaling user feed (Posts) from many sources
I have a scaling issue we are running into. I have a social media app - the user feed has posts from them, posts from the groups they are part of and posts where their groups are tagged in the ...
0
votes
1
answer
19
views
Very slow INSERT performance when using data generation functions
I am trying to get some random data into a table with 1 million entries, and for some reason it is very slow to apply the WAL changes. I am not sure what I am doing wrong here. These are my CREATE ...
0
votes
1
answer
46
views
Mariadb query gives variable performance - why and how to diagnose
I have a simple table
desc house.solar;
Field
Type
Null
Key
Default
Extra
ts
datetime
YES
NULL
measurement
varchar(15)
YES
NULL
unit
varchar(10)
YES
NULL
value
float
YES
NULL
against which I ...
0
votes
0
answers
19
views
Many one-to-one relationships pointing to the same model Django
I'm designing an application in Django where I have an Item model with numerous attributes for each item. I'm experiencing very poor performance in my application and I'm wondering if there are flaws ...
0
votes
2
answers
37
views
Should I convert timestamps in the database or service layer in a spring boot application?
I have a question about data performance
time value is stored as long in my spring boot application.
When I retrieve multiple data, I convert the time using Date_Format FROM_UNIXTIME like below
@...
2
votes
1
answer
81
views
How to efficiently search a large set of documents to find ones that are composed of 90-95% words that exist in a given word set
I'm building a platform that teaches users languages by always showing them content that is slightly above their level (they understand 90-95% of the words, and 5-10% of the words are new to them).
I ...
0
votes
0
answers
30
views
Optimizing PostgreSQL Connection Limits on Windows Server 2019: Balancing Performance and Stability
In our production environment, we are utilizing Windows Server 2019 with 4 cores and 4 threads. Currently, PostgreSQL is configured with a maximum connection limit of 150. However, there are ...
0
votes
0
answers
26
views
Making async and multithreaded operations (queries to a bd) in jupyter notebooks
So i wnat to know if there's a point in making an async and multithreaded queries to a mysql bd, and how can we possibly do this in jupyter notebooks.
How can we insert big tables in mysql efficiently....
0
votes
0
answers
84
views
Postgresql query takes 9 minutes to execute, how can we reduce time to 60 seconds?
Below is my Postgresql query that is taking 9 minutes to execute. Please help me reduce the execution time to 60 seconds, so my API does not throw a timeout error.
SELECT DISTINCT
rdfg....
0
votes
1
answer
58
views
Trying to create an index for a ILIKE query with leading and trailing wildcards, grabbing from a column within a xml data column
I have the following query which is causing performance issues and I am trying to create an index for it:
SELECT inst.policydraftinstanceid, Client.*,
COALESCE( ssn, tin ) TaxId
FROM ...
0
votes
0
answers
20
views
Is it possible to append the data in Redis command
I have 6 workload files like workloads, workloadb, workload etc.
I am using the below command to load the data.
./bin/ycsb.sh load Redis -s - P workloads/workloada -p recordcount=400000 -threads 100 ...
0
votes
0
answers
34
views
In Redis Databases how do we need to calculate the table size
How do we need to calculate the table size in Redis databases
I am able to calculate the size of the db using dbsize command it displays how many count of keys are available in the table but I need to ...
0
votes
1
answer
65
views
Dilemma and strategy for handling big JSON file in React app
So im building application mostly for learning purposes in React.
The app is about car manufactures. So i started building my JSON file(i keep it localy) with all the brands, information and models. ...
0
votes
1
answer
22
views
Select unique rows based on condition stored in another table
I want to select rows based on conditions that is fetched from the database. The tables structure are mentioned below.
# Questions Table:
╔════════════╦═══════════════╦════════╗
║ id ║ ...