2,133 questions
0
votes
0
answers
22
views
Every time I switch between frames on my bottom navigation view their is lag, How do i get rid of it?
I have an (android studio) garden app that uses multiple image/video views that sometimes change depending on the data. For example if the pressure is low the sky changes to a rainy day(if high it is ...
- 23
2
votes
1
answer
370
views
Laggy Android Studio revisited
I never had lag problems with Android Studio (AS) until last year, when I began to experience GUI lag problems: menus take around 2 seconds to open (freezing AS during that time). Also when hovering ...
- 2,671
0
votes
2
answers
64
views
SAS: Conditionally summing a column without having the lead funtion
I cannot conditionally sum a column where the condition looks at rows further down the table. Below is what I am expecting:
Identifier
MONTH
Sum_Me_Pls
On_Off_Flag
focus
seq
Need
1
May-23
0
0
0
1
1
...
- 3
-2
votes
1
answer
46
views
Cursor to update 2 columns based on percentage increase on relevant data on same table
EmployeeName
Date
Salary1
Salary1_Percentage
Salary2
Salary2_Percentage
Alex A
2025-01-01
50
0 %
25
0 %
Alex A
2025-02-01
100
100 %
50
100 %
David C
2025-01-01
50
0 %
10
0 %
David C
2025-02-01
100
100 ...
- 49
3
votes
3
answers
135
views
Nested LAG function (kind of)
I have this table
MachineCode
DoCreation
MachineStateCode
DM139
2024-04-03 00:32:17.377
99
DM139
2024-04-03 00:32:49.080
0
DM139
2024-04-03 01:51:14.427
99
DM139
2024-04-03 01:51:45.643
0
DM139
2024-...
- 85
1
vote
3
answers
77
views
How to get difference value (delta) between to rows after query in Mariadb
Helo,
this is my query:
MariaDB [PV_Anlage]>
SELECT created_at, verbrauch_ges
FROM pv_metrics
group by DATE(created_at)
ORDER BY ID DESC limit 20;
+---------------------+---------------+
| ...
- 23
0
votes
0
answers
15
views
How to restrict kafka stream messages consumption (to avoid external resource starvation)
I created a Kafka stream-based application that performs processing (whatever it is) on files.
The application basically receives "in real time" messages in a topic, and every message ...
- 21
-1
votes
3
answers
90
views
SQL window functions
I've been playing around with dense_rank, LAG, LEAD, ... all kinds of sorting but don't seem able to get this one solved.
Here's a sample of my data and the result I expect/need:
pk_id
pk_id_row_num
...
- 3
0
votes
1
answer
59
views
Python Ursina: way to disable entities far away to decrease the lag?
I wouldn't call it much of a problem, but it really affects a project I'm working on.
Now, I do understand that running a Minecraft clone with 1900 blocks isn't a good idea if you want high FPS, but ...
1
vote
1
answer
141
views
Track Latest Changes of a Column
Here is the desired outcome: when a sale is created, it is considered a 'Lead', and we have a different LeadStage. Once a Lead is secured, it will be converted to an Opportunity with an alternative ...
- 53
0
votes
0
answers
32
views
Changing width and position of my div element using JavaScript and a transition style becomes very laggy
monthlyButton.addEventListener('click', () => {
if (planTerm === 1) {
basicPrice = prices.monthly.basic;
essentialsPrice = prices.monthly.essentials;
premiumPrice = prices....
0
votes
1
answer
75
views
Tkinter lagging when data received from Arduino using serial module
I am trying to receive data from Arduino with a simple loop, sending data every 100 ms. I am trying to pull the same thing using Tkinter and display it on Canvas. but data is lagging. I tried queue ...
1
vote
2
answers
87
views
R Iteratively modify values based on previous row if a condition is met
Here is a sample of my df:
library(dplyr)
# Create the dataframe
df <- data.frame(
id = c('A', 'A', 'A', 'B', 'C', 'C', 'C', 'C', 'D', 'D', 'D'),
supply_start_date = as.Date(c('2024-01-01', '...
- 435
0
votes
0
answers
68
views
How to pick change values from a column other than using window functions in Snowflake
I have a Snowflake table with data like below:
Table1
Col1 Col2 Col3
G1 1 9:15
G1 1 9:16
G1 2 9:17
G1 1 9:18
G2 1 9:15
G2 2 9:16
I want to ...
- 564
0
votes
1
answer
60
views
R: difftime with lag to create another column
I have a dataset where each row is a cluster, and I want to know which clusters fall within the previous cluster, or 12h after the previous cluster ended.
My dataset looks like this:
cluster_id ...
- 489