drupal7

1. Download boost module and enable.

2. Disable page anonymous core cache, Configure boost settings and .htaccess settings.

3. Copy .htaccess generated to drupal root .htaccess

If can't login update boost .htaccess

from

RewriteRule .* - [S=4]

to

RewriteRule .* - [S=1]

Use

Hook_views_query_alter(&$view, &$query)

Example code:

Create a php script with a header #!/usr/bin/env drush

my_php_script.php
#!/usr/bin/env drush
<?php 
echo drush_get_option('param');
exit();

Drush command to run the php script from cli

$ drush scr my_php_script.php --param="this is a test"

  $term = new stdClass();
  $term->name = $name;
  $term->vid = $vid;
  taxonomy_term_save($term);
  return $term->tid;

  $node = new stdClass();
  $node->title = "TITLE";
  $node->type = "NODE_TYPE";
  node_object_prepare($node); // Sets some defaults. Invokes hook_prepare() and hook_node_prepare().
  $node->language = LANGUAGE_NONE; // Or e.g. 'en' if locale is enabled
  $node->uid = $user->uid; 
  $node->status = 1; //(1 or 0): published or not
  $node->promote = 0; //(1 or 0): promoted to front page
  $node->comment = 1; // 0 = comments disabled, 1 = read only, 2 = read/write

  // Term reference (taxonomy) field

Drupal 6 and 7

$ drush cc

$ drush sql-dump > ~/my-sql-dump-file-name.sql

Drupal 8

$ drush cr

$ drush sql-dump > ~/my-sql-dump-file-name.sql

Download Database from the server

$ scp username@example.com:~/my-sql-dump-file-name.sql ~/projects

Import Database

$ drush sql-drop

$ drush sql-cli < ~/my-sql-dump-file-name.sql