I have a query like this: EXPLAIN SELECT b.* FROM bills b WHERE (b.id IN (SELECT u.id FROM bills u WHERE u.updated BETWEEN '2023-12-19 14:17:48' AND '2023-12-19 14:27:40' AND u.organisation_id = 'ABC123') OR b.id IN (SELECT c.id FROM bills c…
When a queryset is sorted by a field in a related model performance decreases drastically. I use mysql. For example, I have two models: class Event(models.Model): idEvent = models.BigAutoField(primary_key=True) created_at = models.DateTimeField(db_index=True, verbose_name=_('date')) processed_at = models.DateTimeField(auto_now_add=True, verbose_name=_('processed')) data = models.TextField()…
I need to specify "value/key" pairs within my URL to add data in a mySQL DB. For example : adding values of 'x' and 'y' with mysite.com/myphpscript.php?x=1&y=2. This works, but now, if a "value/key" pair is missing, like so :…
Help! I have a MySQL table with a JSON column in it. A while back I pushed a change that filtered a PHP array but without resetting the array keys, so that when it got converted into JSON the array…
I am trying to calculate sum of time. Everything is working fine but sum of time displaying one hour extra. For example if sum of time need to be 20:23, its displaying 21:23. I dont knew why its given one…
I'm writing a query in MySQL for a Grafana dashboard, but the performance of only this particular query is very poor. This is the query: SELECT br.reading ,CONCAT(ino.project,"_",SUBSTRING_INDEX(br.sensor,"_",-1)) AS new_metric ,ino.vessel ,ADDTIME(DATE('2023-01-01'),-TIMEDIFF(ino.date,br.datetime)) AS norm_date ,br.sensor FROM db.milestones br INNER JOIN…
From sourcetable "amazon_order_history_2022" and column "Betrag" (datatype: varchar) I want to calculate a new column, that classifies data from column "Betrag", wether it smaller/equal to 100 or bigger than 100. So far the code is working. Then I want to…
I have a three table. When I execute below query it takes 3 to 5 min. SELECT u.Id,cmc.completionstate,cmc.coursemoduleid FROM User u JOIN role_assignments ra ON u.id =ra.userid LEFT JOIN course_modules_completion cmc ON u.id=cmc.userid LIMIT 1000000000 Execution Plan: id select_type table…
I am developing a website for a charity where amounts are pledged by individuals and recorded into a table. The individuals belong to a group. The payments received are recorded in another table however they are tagged to a group…
I have a server with an IP address, username, and password provided by my manager. My website is built using React.js, with a MySQL database, and version control managed through GitLab. How can I deploy my website on the physical…