Adam Kiss adamkiss

## Retour Query Optimization.md

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              1 star
            
          
                adamkiss
                / Retour Query Optimization.md
            
            
              Last active
              March 18, 2020 14:59
            
              
                Retour Overview Query Optimization
              
          
    SQL Optimization — Retour database, events overview

@distantnative asked me (well, anyone) to optimize a SQL query which generates an overview of Retour events.
#Programming/SQL
Original Query

with recursive dates as (
    select "2019-10-01" as date
 union all

  
## nr.fish
#!/usr/bin/env fish

function nr -a script --description 'npm run shortcut with default script set to "start"'
    if not string length -q $script
        set script start
    end

    npm run $script
end

## index.php
<?php

use Kirby\Cms\App;
App::plugin('adamkiss/simple-snippets', []);

if (! function_exists('s')) {
	/**
	 * Short, auto-return snippet call with support for auto-merging certain parameters
	 *
	 * @param string $snippetName
	#!/usr/bin/env fish

	function nr -a script --description 'npm run shortcut with default script set to "start"'
	if not string length -q $script
	set script start
	end

	npm run $script
	end
	<?php

	use Kirby\Cms\App;
	App::plugin('adamkiss/simple-snippets', []);

	if (! function_exists('s')) {
	/**
	* Short, auto-return snippet call with support for auto-merging certain parameters
	*
	* @param string $snippetName