dtt | data transfer between linear algebra libraries | Computer Vision library

To order by the earliest of two columns you have to add an annotation that calculates the earliest of the two using Least, then you can order by the annotation

If you create your daa and dtt variables inside the For-loop, they will be "destroyed" at the end of every loop execution and re-created in a next loop execution. That has to do with scope. If you actually want that to happen depends on how you intend to process the data on your dashboard. You only show code that retrieves data from the database, so based on the code you provided it cannot be determined what the "correct" way would be in your scenario.

You should also mind that several objects can (and should) be disposed if you are done using them. If you fail to properly dispose such objects (like your DataTable and OleDbDataAdapter instances), they will stay "alive" somewhere in your computer's memory (probably until the application is terminated). Apart from eating memory, they might hold other system resources occupied as well. That can be one of the main reasons why your program becomes "heavier" in the course of time while it is running.

Finally, I would suggest to combine all those separate SQL queries in a single SQL query. Then you can execute that single query every 10 seconds. Every query you execute has some overhead, so combining them as much as possible will almost always be somewhat faster.

There are at least two possible strategies for creating a single query for your scenario. One querying strategy uses multiple subqueries:

Does this answer your question?

The description of the question and the query seem to have little to do with each other. I don't know what a "pivot table" is supposed to be.

I would like a query that has a combination of dumpster_types, haul_types, and drivers (users) and a count of the hauls they were involved in.

This sounds like a cross join to generate the rows and then a left join/group by to calculate the results:

To apply the multiple conditions in ngStyle we should use conditional operator. use below code ( here I have used conditions for 121, 122 & 123 you can add as many as you want):

Template:

If you are doing a post request with Ajax, then you have to write in your ajax code like

This is mainly a subsetting problem.

if [[ "$(echo $msg | grep -i 'No such file or directory')" = 'No such file or directory' ]] should be if grep --ignore-case --quiet 'No such file or directory' <<< "$msg":

1. grep returns the whole line, including the "test: line 4: /var/lib/dtt: " bit, which is not equal to the text you're looking for in the [[ command. You can use --only-matching to print only the part of the line matching the regex.
2. grep exits with code 0 if it finds a match.
3. Since you don't need to print the match (and to speed up existence checks in larger inputs), you can use --quiet to just exit as soon as it finds a match, without printing it.
4. if just checks whether the command after it returns exit code zero. [[ is just another command, like grep.
5. Long option names (while not available in all incarnations of grep) make it obvious what the command is doing, rather than obscuring it.
6. You very rarely need to use echo (or cat, another often abused command) to send things to standard input of commands. A here string is handy for this case.
7. Finally, Use More Quotes™ :)

You need to round the minutes and then reformat your output date.

There's some gotchas hidden in here. As you can end up with 60 minutes (should be 00) and 24 hours (also should be 00). So special checks are put in place to catch that.

Also, you way of getting the current time is very convoluted. Getting "now" gets the same value which is what DateTime() gets by default.