optimization   67706

« earlier    

avoid OR for better PostgreSQL query performance - Cybertec
PostgreSQL query tuning is our daily bread at Cybertec, and once you have done some of that, you’ll start bristling whenever you see an OR in a query, because they are usually the cause for bad query performance.

Of course there is a reason why there is an OR in SQL, and if you cannot avoid it, you have to use it. But you should be aware of the performance implications.

In this article I’ll explore “good” and “bad” ORs and what you can do to avoid the latter.
postgresql  optimization  performance 
2 hours ago by micktwomey
Advanced Content Tracking with Google Analytics: Part 1 - Analytics Talk
the objective here is to get a better understanding, on a page by page basis, of the content that visitors engage with. Using some objectives suggested by Thomas Baekdal here’s what we’re going to track:

How many people scroll
When a person starts to scroll
When a person reaches the end of an article (not the end of the page, but the end of the article or post area)
When a person reaches the botton of the page (the bottom of the HTML)
Which website visitors are scanning my articles and which are reading my articles
Think about the value here! We will be able to get an accurate measure of which articles are actually read. We can even see which articles are so engaging that visitors continue through the comments to the botto of the page. Very useful stuff.

Tracking Technique

All of the above can be tracked with Event Tracking. The concept is that we will fire events when certain actions happen. Specifically we’re going to fire events based on visitors scrolling down the page.

Critical to any event tracking implementation is the data model. We need to define the data we want to see in Google Analytics.

All of the reading activities will be grouped together into a category named Reading.

Within this category there will be four main actions:

Article load: Measure how many times the article loads in a browser. Basically another count of pageviews. This will provide context to the other events that we track.
Start Reading: Track when a visitor starts scrolling down the page. This will be triggered after a visitor scrolls 150 pixels down the page. This value can be customized. I’m also tracking how much time it takes to start scrolling.
Content Bottom: Track when a visitor reaches the end of the article content. And track how much time it took between the scroll start and getting to the bottom of the content.
Page Bottom: Track when the visitor reached the botton of the page and how long it took.
Another piece of critical information is the page URL and title. We need this to segment the data and see which articles are most engaging to people. Google Analytics will automatically track the page URL and title so there’s no need to add it to the event.

We’re also going to use a Custom Variable to place this visitor in a bucket. If it took them less than 60 seconds to get to the bottom of the page then I will assume they are just scanning. We’ll put them in the Scanners bucket.

But, if they took longer than 60 seconds to get to the bottom of the page then we’ll put them in the readers bucket.

FInally, I can set these events up as goals. I’ll add one goal for those that make it to the bottom of the content and one goal for those that make it to the bottom of the page. This is an easy way to measure what percentage of visits complete these actions.
analytics  content  seo  optimization  tracking  metrics 
16 hours ago by rmohns
On the history of the transportation and maximum flow problems
We review two papers that are of historical interest for combinatorial optimization: an article of A.N.Tolstoi from 1930, in which the transportation problem is studied, and a negative cycle criterion is developed and applied to solve a (for that time)large-scale (10X68) transportation problem to optimality; andan,until recently secret,RAND report of T.E.Harris and F.S. Rossfrom 1955, that Ford and Fulkerson mention as motivation to study the maximum flow problem. The papers have in common that they both apply their methods to the Soviet railway network.
networks  combinatorics  optimization  algorithms 
17 hours ago by rvenkat
Image and Video Upload, Storage, Optimization and CDN
CDN with facial recognition and cropping that has a generous free tier, neato
api  cdn  images  webdev  hosting  free  tools  optimization 
yesterday by inrgbwetrust
the new code – SVG Optimisation: The Basics
While the SVG format is extremely efficient in storing illustrations, vector files can become just as bloated as their bitmap kin.
optimization  svg 
yesterday by kogakure
[1805.08166] Learning to Optimize Tensor Programs
We introduce a learning-based framework to optimize tensor programs for deep learning workloads. Efficient implementations of tensor operators, such as matrix multiplication and high dimensional convolution, are key enablers of effective deep learning systems.
tensorflow  machinelearning  optimization 
2 days ago by peterb
Optimize animated GIF
Perfect for converting a gif into something that Slack accepts!
gif  tools  online  optimization  5 
2 days ago by VoxPelli

« earlier    

related tags

2018  5  abstraction  accessibility  ai  algorithm  algorithms  amazon  amp  analysis  analytics  analyze  animation  api  architecture  article  arxiv  assembly  audit  bigdata  binary  blogs  build  building  business  c++  c  cdn  cli  code  coding  combinatorics  command  compiler  compilers  complexity  compression  computers  concurrency  constraint-progamming  constraint  content  convexanalysis  copy  cpu  cpu_architecture  cs  css  cssbasics  cython  database  datascience  debug  deep-learning  demoscene  development  devtool  devtools  directx  disk  django  editor  elixir  experimental  facebook  filesize  firebase  float  floating-point  free  gif  go  golang  google  googleio2018  gradle  graphics  grep  hadoop  haskell  high  hn  hosting  howto  ieee754  image  imageprocessing  images  important  jake  java  javascript  jpeg  jpg  js  landingpages  language-design  languages  learning  library  linear_algebra  linearalgebra  links  linux  list  llvm  load  loadtesting  logic-programming  logic  mac  machine-learning  machine.learning  machine_learning  machinelearning  maintenance  mapreduce  match  math  matrix  memory  mental  metrics  microsoft  mobile  model  networks  neuralnetworks  nodejs  notepad  numpy  ocaml  online  opensource  organization  orm  page  papers  parallel  parser  parsing  perfmatters  performance  performancetuning  photography  pix  plugin  png  postgresql  profiler  profiling  profvis  programming  psychology  python  r  react  reason  reasonml  reference  repo:github  research  resources  responsive  review  rust  scala  scalding  scipy  search  seo  shiny  simd  site  slowness  software  solvers  speed  sql  ssd  sseo  stackoverflow  startup  stata  statistics  storage  string  svg  svgo  tdd  techniques  tensorflow  testing  text  thinking  tips  tool  tools  tracking  transparent  trends  tuning  tutorial  ui  utility  ux  variant  vector-graphics  web  webdev  webdevelopment  website  whitepapers  windows  wordpress  xamarin  xml   

Copy this bookmark: