rube | composable data validation , transformation & manipulation | Validation library

Our warehouse management package has a bottleneck (one of many) with a stored procedure and the major slowdown is due to the query that produces this execution plan.

https://www.brentozar.com/pastetheplan/?id=HkNg65elP

The stored proc can take anywhere from 3 to 10 seconds to run which is quite slow in the context of the business process it runs in.

Some additional info: Yes, there is one table where a full table scan is being done, but this table is narrow, and only has 76 rows. The query does some left joins and some sorting which is needed to produce the correct top result. Overall, it is a bit of a "Rube Goldberg" type query and could probably be simplified, but my goal is to see if it is possible to help with some indexing (which I've done and it's helped a little) or even some small tweaks to the query if needed.

In the end, I need to know where to focus next based on the plan.

Here is the query:

I am looking at analyzing text files which have a known structure. Before going into a Rube-Goldberg-machine kind of solution I wanted to check if there was a standard approach to such problems.

The file structure is

Hey guys I haven't done web dev in a while. I have made my site what I thought to be responsive using flexbox.

Also first time posting here. Please let me know what the conventional ways of getting help is if this is an influx of information.

I have two pages in total. A home page and a gallery showing all my work.

Some HTML elements(videos) have a library attached to the semantics to get rid of javascript. In this case I'm using AOS (Animate on scroll).

Anyways, I made the first page (Home) responsive to iphoneX but I cannot get the gallery page responsive in any way, shape or form and it is driving me crazy.

I'm aware that there are probably LOTS of errors and easier way to do things.

Aside from the responsiveness of the gallery page - please share tips on how I can change some things.

If you're confused as for what I'm asking. Just help PLEASE with the responsiveness of the gallery page for and iPhone X and iPad.

Thanks!

I am trying to find out the surface area of each of the faces of a cube and the corresponding outward unit normals. This operation is done on a finite element mesh, so I have transformed each surface of the cube into the isoparametric form using shape(basis) functions and then tried to extract the area and normals.

Here is the code:

I've been looking into this issue for a while, I hope to get some clarification here.

I have developed a Template class. One of its methods takes for input two functions with different parameters, as follows:

Intro

I am trying to have an alexa communicate with a dragonboard to turn on an LED. I am using aws' iot core javascript sdk to listen for mqtt calls and python-shell to execute a python script to blink the LED. I modified device-example.js to look as follows

device-example.js

I have a large data set divided into many small groups by a grouping variable = grp; all members of a group are contiguous in the order of the larger data set. The members of a group each have an id code (= id) and are numbered sequentially from 1. Within a group, some members meet a logical criterion = is_child. Each member has a variable (momloc) that contains either zero or the ID number of another of another group member (the mother if present).

I wish to assign to each individual in the data set the number of group members who has momloc equal to their ID, and zero if none do. I am trying to do this in dplyr as I have the groups set up there, and I have code that works, but it is a Rube Goldberg contraption of nested ifelse functions that adds two additional columns for intermediate values, one of which contains a vector, goes through the data set three times, and is incredibly slow. There has to be a better way than that. I'm getting tangled in the different syntax for mutate, working on rows, and summary, working on groups.

Below is a simplified data set and desired outcome

Noob to Rubes. I have an array which I built in a js file that I am inserting into a text area. This works fine, but when I submit my form the array looks like this ["68\r\n67\r\n66"]. I just want the song list array (see below controller) to look like [68,67,66]

I'm very new to rails and am having some trouble. I have a model called BusinessDates that consists of two tables, calendar_date and seasonality (you can ignore seasonality). What I'm trying to achieve is to be able to move through them easily like folders.

It took me a few solid days of google-foo, but I was able to have the index display a list of each unique year in order as links with friendly_ids. From here I want to click on it and have it link to a new view that displays a list of each unique month in that particular year in order as links with friendly_ids. Then (as you could guess) have it display on another new view a list of all the days in the selected month in the selected year. I want the url to be business_dates/2016/5/21 or in other words business_dates/(year)/(month)/(day).

My issue: I don't know where to go from here. I can't even seem to find any info on making a second level deep non-static url without either making each year month and day separate models (want to avoid that), or what looks like a rube goldberg machine to kinda get there but without views for each page (You'd have to just type the full date into the url).

Please help a beginner who feels very lost!

Controller: