- Don’t
SELECT *
, Specify explicit column names (columnar store) - Avoid large JOINs (filter each table first)
- In PRESTO tables are joined in the order they are listed!!
- Join small tables earlier in the plan and leave larger fact tables to the end
- Avoid cross joins or 1 to many joins as these can degrade performance
- Order by and group by take time
- only use order by in subqueries if it is really necessary
- When using GROUP BY, order the columns by the highest cardinality (that is, most number of unique values) to the lowest.
/* requires AWS creds to be updated. | |
* if they aren't, update using AWS.config.update() method before instatiing the client. | |
* | |
* import this module where you instantiate the client, and simply pass this module as the connection class. | |
* | |
* eg: | |
* const client = new Client({ | |
* node, | |
* Connection: AwsConnector | |
* }); |
Hey everyone - this is not just a one off thing, there are likely to be many other modules in your dependency trees that are now a burden to their authors. I didn't create this code for altruistic motivations, I created it for fun. I was learning, and learning is fun. I gave it away because it was easy to do so, and because sharing helps learning too. I think most of the small modules on npm were created for reasons like this. However, that was a long time ago. I've since moved on from this module and moved on from that thing too and in the process of moving on from that as well. I've written way better modules than this, the internet just hasn't fully caught up.
@broros
otherwise why would he hand over a popular package to a stranger?
If it's not fun anymore, you get literally nothing from maintaining a popular package.
One time, I was working as a dishwasher in a restu
Author,HyperlinksChanged,LinksUpToDate,AllowPNG,Version,Template,Revision,Company,LastSaved,Characters,Pages,Words,Created,Bytes,LastAuthor,Lines,AppVersion,CharactersWithSpaces,OfficeDocumentSettings,DocSecurity,ShareDoc,TotalTime,url,RelyOnVML,ScaleCrop,PixelsPerInch,Paragraphs,Keywords,LastPrinted | |
Jakobína Sveinsdóttir,,,,10.2625,,2,Hæstiréttur Íslands,2003-03-29T12:44:00Z,4138,3,725,2003-03-29T12:44:00Z,16384,Gummi,34,,4854,,,,4,http://www.haestirettur.is/domar?nr=4,,,,9,,1999-01-12T10:23:00Z | |
Jakobína Sveinsdóttir,,,,10.2625,,2,Hæstiréttur Íslands,2003-03-29T12:43:00Z,6308,3,1106,2003-03-29T12:43:00Z,19456,Gummi,52,,7400,,,,70,http://www.haestirettur.is/domar?nr=6,,,,14,,1999-01-11T13:36:00Z | |
Ritari 2,,,,10.2625,,2,Hæstiréttur Íslands,2003-03-29T12:42:00Z,46891,19,8226,2003-03-29T12:42:00Z,69632,Gummi,390,,55007,,,,176,http://www.haestirettur.is/domar?nr=7,,,,110,,1999-01-14T08:38:00Z | |
Skúli Magnússon,,,,10.2625,,2,Hæstiréttur,2003-03-29T12:40:00Z,5058,3,887,2003-03-29T12:40:00Z,25600,Gummi,42,,5934,,,,34,h |
<script src="https://cdnjs.cloudflare.com/ajax/libs/crossfilter/1.3.12/crossfilter.js"></script> | |
<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.js"></script> | |
<script src="https://cdnjs.cloudflare.com/ajax/libs/dc/2.0.0-beta.20/dc.js"></script> | |
<script src="updatingCrossfilter.js"></script> | |
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/dc/2.0.0-beta.20/dc.css" /> | |
<div> DC Version: <span id="version"></span></div> | |
<div id="timechart"></div> | |
<div id="histogram"></div> | |
<script> | |
var getData = function (d) { return {ts: d, y: Math.random()* 2 -1 }; }, //get a data point |
Standard for US Driver's Licenses defines 9 different barcode standards (AAMVA versions) with over 80 different fields encoded inside a barcode. Some fields exist on all barcode standards, other exist only on some. To standardize the API, we have structured the fields in the following sections:
It seems that Chrome finally found a way to let us convert from svg to canvas to png without the tainted canvas security feature/bug.
A goofy slippy map of various vector tile data sources. With some fun colours, greetz to Aaron and Mike and Mike and the whole Prettymaps crew.
Sacramento, CA • SF bay area, CA • New Orleans, LA • Boulder, CO •
<!-- ALL CREDIT FOR THE SCROLLING TEXT GOES TO | |
Craig Buckler | |
http://www.sitepoint.com/css3-starwars-scrolling-text/ | |
Blame me for the music via embedded video bit | |
--> | |
<div style="border:1px solid darkred;overflow:hidden; position:absolute; left:0; top:0; width:50px; height:25px;"> | |
<div style="margin-top:-290px;"> | |
<object width="420" height="315"> |