⛰️ Hi comunity, I'm using a normal MySQL query to join 2 tables. My query in a simpler way looks like these (for these example i just put *, otherwise i have targeted elements) SELECT table1.*, table2.* FROM table1 INNER…
I have a table with these columns: id (int) col1 (int) col2 (varchar) date1 (date) col3 (int) cumulative_col3 (int) and about 750k rows. I want to update the cumulative_col3 with the sum of col3 of same col1, col2 and previous…
I'm working on a rights verification system. In order to verify that the user has access to the documents, I make a request to the database There are 2 cases when you can get access: The user is in the…
I have a users table with bio field and "n:n" relationship with itself via the followers table so each user U can follow many other users. My user search query is super slow. All queries get the first 20 search…
The below query finds one id by using the below query format but it seems I have indexed all columns, but it took time to execute between 54.3 seconds - 1.2 mins. What can I try next? Query: select op.ord_prod_id…
I have a table with close to a billion records, and need to query it with HAVING. It's very slow (about 15 minutes on decent hardware). How to speed it up? SELECT ((mean - 3.0E-4)/(stddev/sqrt(N))) as t, ttest.strategyid, mean, stddev,…
So I have a table of 4.7 billion records on which I want to perform a group by count expression in Postgres using PGadmin4. Obviously this is gonna take a lot of time and I want to speed up the…
I'm completely new in mysql and struggling to write a store procedure to get a required result set. As you can see below are the tables I have, I'm using node & express api to connect to mysql database. Then…
the below query it scans more rows while the table has an index on it but not using that index for that column. Query; SELECT * FROM st_aepsrequest_log WHERE `snd_transno` IN ( SELECT pwcashout_transno FROM st_aeps_transaction_master a WHERE a.`entry_date` >=…
I have a query. It has an index but I'm not sure why it's taking time for fewer rows. Can anyone please suggest to improving that query performance? SELECT up.id post_id, c.id community_id, SUBSTRING(up.description, 1, 30) post_description, c.name community_name, c.is_index…