All Questions

I'm working with IoT device sensor data. The table structure is as follows (TSDB engine, partitioned by date and device): // Sensor real-time data table db_date = database("", VALUE, 2024....

I am working on a backend application and trying to reduce response latency, but I want to avoid optimizations that could introduce correctness issues. By correctness, I mean preserving accurate ...

I'm displaying an ALV using CL_SALV_TABLE in a custom container, but even though I call lo_columns->set_optimize( abap_true ), the header columns all appear the same width and are not auto-adjusted ...

I made my own 3D render with Pygame and added basic .obj import, but even a teapot lags a lot because vertices 2d array's length is long. How can I optimize code as much as possible inside game loop? ...

I’m working with a WordPress website that has been running for a few years and the database size has grown significantly. I noticed that some queries and page loads are slower than before. While ...

How to decide I am trying to understand how to properly use repartition and coalesce in Apache Spark, especially for performance optimization. From my understanding: repartition can increase or ...

I have an excel spreadsheet of results for the analysis of beams in a building. For each beam I have 6 different loads for 6 different situations. These loads are not linearly related, sometime a beam ...

I am implementing Domain-Driven Design (DDD) and facing a problem: balancing database performance with clean domain modeling. I want to stop loading child entities that I don't need when getting an ...

Problem Statement: We are running a Java/Spring GET/POST getAll pagination API on top of MySQL in AWS RDS and need help optimizing exact filtered counts Current state: The main dataset is courses with ...

I have a PostgreSQL table foo partitioned by date (monthly partitions). The table currently contains ~13 million rows and continues to grow. This query runs any time someones opens the dashboard of ...

I tried making a logistic regression model using nn.Module class LogisticRegressionModel(nn.Module): def __init__(self, input_dim= None) -> None: super().__init__() if input_dim ...

For robust ray–triangle intersection, it turns out that the following must be exactly true in floating-point math: a*b - c*d = -(d*c - b*a) There is no problem if this is computed as two ...

I need a function that behave like np.random.choice, but that takes the argument "p" to be a 2-dimension array, of which each row is a probability. The function should return a sample from ...

I’m trying to maximize the profit of a battery that can charge r_i or discharge q_i, with wholesale electricity prices P_elec,i, within a n=24 hour period. (eta is just the efficiency of the battery, ...

Hi all — I’m debugging an unexpected ordering/progress issue with peer-to-peer device copies and I’d like help understanding what CUDA/driver/runtime behavior could explain it. Setup Single node, 2 ...