All Questions
Tagged with database performance
2,519
questions
-2
votes
1
answer
41
views
How does Tinder gives me only new profiles? [Database design]
I have probably swiped 10k profiles either left or right.
If I open the app tomorrow I will get 10 profiles I have never seen.
How can these profile be queried efficiently?
For sure an SQL query of ...
0
votes
1
answer
51
views
Efficiency of Redis compared to relational DBs in Python
Edit: pipelining in redis script is used to execute commands in batches, it doesnt connect to the remote server for each operation
I use connectionpool for Redis to maximize the network delays
Edit2: ...
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
21
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
20
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
84
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
31
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
27
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
59
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
35
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
68
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. ...