I am trying to measure at which workloads' pthreads become useful. So far, I found that workloads need to take around ~3ms for pthreads to contribute positively to the overall progress (on an Alderlake test system). Is this the correct…
I have a case where users may have access to some content with subscriptions, it's not video streaming but I will write an example with that for easier understanding: users in "basic" subscription have access to some basic videos (ID…
Im' quite new to full stack development (coming from UX design). I'm asking in the direction of software design and database query strategies. Quick example: Imagine you have a database with booking for a service including customer info and start…
I have an application developed on PHP codeigniter ('CI_VERSION', '2.2.6'); and Mysql. this is hosted on XAMPP. The application was running fine and suddenly on may 22 the CPU usage has gone up to 95%. and mysqld shows more that…
I have an input table like this: Load_date projected_date current stock consumed demand 2020-01-01 2020-01-01 100 15 2020-01-01 2020-01-02 150 80 2020-01-01 2020-01-03 200 25 2020-01-01 2020-01-04 300 70 2020-01-01 2020-01-05 400 65 My intermediate output will be like this:…
I'm using MySQL 8.0.35 and I've two tables in my database: users and clients. Users can be searched by username, firstname, lastname, email, phone, document or even id. The clients table is used to track which users are clients of…
How are you? I am using memcached for a while now and love it. Bheind the cache I am tipicly using Postgress or any relational database. There are some cases when using cache make it complex. and I am not…
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 @Query("SELECT new today.feeling.dto.response.emotion.EmotionMonthlyReportQuery(" + "s.id, " + "s.studentId,…
I have a deeply nested JavaScript object structure representing a hierarchical data model. The object can have multiple levels of nested children, and I need to search for a specific value within this structure. Here is an example of such…
I am about the compare two dates in JavaScript with each other for example consider this two value : date1 = 2024-5-13T20:30:00 date2 = 2024-5-13T21:30:20 the day and month is the same but the hours is different my goal is…