php – Warning: Illegal chain lag & # 39; totalfuncionarios & # 39;

I have created a view in the database to display the total number of rows in a table. It always returns the same error, "Warning: illegal string offset" totalfuncionarios ". I will show you the code soon.

panel.php




    

select.php

function selectViewFunctional () {
$ bd = connectBank ();
$ sqlViewFunctional = "SELECT * FROM totalfunctions";
$ result = $ bd-> query ($ sqlViewFunctional);
$ row = mysqli_fetch_assoc ($ result);
return $ row;
}

Use the lag function in mysql to get the previous values

I'm trying to create a MySQL dataset containing entries from previous studies (surgical study, the first study worth 1) as well as for this user ID. Each user can have multiple studies. I'm trying to use the Lag function to get the data from the previous study. I get duplicate values ​​for study 1 when trying to use lag function.

WITH Complete_Data AS (
SELECT *
FROM Data
GROUP BY UserId, studyno
)
SELECT *, LAG (indication_of_chill, 1)
MORE THAN (
PARTITION BY UserId
ORDER BY studyno
) prev_study_indication_of_failure
,
LAG (BCVA_State, 1)
MORE THAN (
PARTITION BY UserId
ORDER BY studyno
) prev_study_BCVA
OF
Complete_Data
GROUP BY UserId, studyno
;

I expect null values ​​in prev_study_indication_of_failure and prev_study_BCVA when studyno = 1 but filled with values ​​when studyno> = 2.

Due to duplicate entries for studyno = 1, I get values ​​in prev_study_indication_of_failure and prev_study_BCVA

SQL Server – How to Properly Index a Table to Optimize LEAD / LAG Window Functions

I have an R table that contains 1.3 billion rows with a primary key and a unique clustered index on the S, L, P and Date fields. When I execute a query on R alone with LEAD or LAG window functions or by limiting the partition by ROWS:

OFFSET ([SomeData], 1) OVER (PARTITION BY S, L, P ORDER BY Date)
AVG ([SomeOtherData]OVER (PARTITION BY S, L, ORDER BY Date ROWS N PRECEDING)

the execution plan has an unnecessary sort on S, L, P and RowNumber. It's useless. The date must be unique for all S, L and P. In addition, if I perform a SELECT TOP (N), the 1.3 billion rows are analyzed when N lines only are needed.

Curiously, this problem does not occur at all if I do not have a partition on my LEAD / LAG function nor to use RANGE instead of ROW for framing:

OFFSET ([SomeData], 1) OVER (ORDER BY S, L, P, Date)
AVG ([SomeOtherData]) OVER (PARTITION BY S, L, ORDER BY Date Range PRECEDING UNBOUNDED)

but then I do not have proper frames. What should I do differently on the index or query hints to prevent unnecessary sorting and full analysis of the table?

Youtube – 4k 60fps – Deleting frames (Stutter / Lag / Freezes)

I'm trying to watch 2160p content (4k 60fps) on Youtube, but I'm experiencing a lot of image loss … that is to say that the video freezes / stammers completely ( the sound is perfect).

The Youtube example I use: Costa Rica – 4k 60fps – Youtube

If I watch the video in 1440p, it is read without any lost image. However, when switching to 2160p, the video freezes / stutters due to the considerable number of image losses (80%), see below.

Lost Images - 28 sec. - Youtube 4k 60fps

As a result, my Internet is stable and thin (via cable) and I use the VP9 codec in combination with HTML5 and Mozilla Firefox / Microsoft Edge (same result). I do not use hardware acceleration.

My PC specs .:

  • MSI H97M-G43
  • Intel Core i5-4460 in a box
  • MSI GeForce GTX 1080 GAMING X 8G
  • Crucial Ballistix Tactical BLT2C4G3D1608ET3LX0CEU
  • Seasonic M12II Evo 620W
  • LG 27UK850-W Zilver
  • Windows 10 Education (Professional Edition) – Version 1803 – Build 17134.590
  • Nvidia Driver – 25.21.14.1771 (NVIDIA 417.71)

Therefore, in my opinion, it should be enough to watch 2160p videos on Youtube? The processor is a little stressed, but the use is about 80%. The graphics processor barely works because the 2160p content requires a lot of decoding by the processor.

Current (after 28 seconds) – Min – Max:
CPU - 28 sec. - Youtube 4k 60fps

Does anyone have an idea of ​​what is wrong / how to fix it (software configuration or does it really mean the processor)? Thank you for any information!

Latency, Lag, CRON Media Library?

When I add images to my media library, these are not available for about an hour. It seems that there is a queue or some sort of CRON that goes off. The image appears in the media library as a transparent image for the time being.

How can I load the image to load when I download it?

The images worked previously, but I'm now downloading to S3 with a CRON that fires every minute. Maybe this concerns the question.

Editing panel that shows the picture correctly:

Editing panel with image

Media library that shows pause:

broken media display

lag – Why do EU players get a higher ping when connecting to a Chinese server during the day, as opposed to the night?

My apologies if this is the wrong place for this. I have been referred to this forum as it is a server problem.

There is a server I play frequently in China; I live in Europe and I naturally have a higher ping in general. However, I noticed that during the night when no one is playing, I have a lower ping than during the day when I have a higher ping. (250 pings a day and 200 a night)

Questions:

What is causing this specifically? Is it simply due to more players putting more load on the hardware, making the network more tense, or is there anything else?

Please, close this if it is not relevant for this forum, I am not sure whether it is the right place or not personally.

network – Several LAG ESXi vDS

Currently, the network design includes 2 switches and each ESXi host has 4 network cards. 2 NICs are connected to switch # 1 and 2 NICs are connected to switch # 2. As these are different switches, it is not possible to create an etherchannel with all 4 NICs. So, the best thing I can do switch side is 2 different etherchannels.

vDS has several port groups. Currently, it uses an active LAG from 2 NICs on switch # 1. The idea would be to enable 2 active LAGs (with the remaining NICs on switch # 2) on the same VDS, but this is not possible (at least I was not allowed to create).

What would be the best configuration to reach both active LAGs for the same port group? Unfortunately, these are just 1G connections and it would be good to have the four active people on the team. Even though it's 2×2.

Where can I get details of my competitor's TIME LAG conversions?

Hi guys,

Hello, I am working on the website of an ECOM client, we have activated ecom tracking and collected the details of the conversion. my client wants to know the conversion time of our competitor.

For example, here is an example of screenshot taken from the analysis, is there a possibility to know the time offset of our competitor (not Google, neither conversion values ​​nor figures, do you just have an idea of ​​the conversion time)? any other tool or source to collect the data.
SEMrush

Please advice, it would be a great help to people.

timelag.png "class =" bbImageCode LbImage