diff options
| author | Steven Wittens <steven@10.no-reply.drupal.org> | 2007-03-19 01:17:37 +0000 |
|---|---|---|
| committer | Steven Wittens <steven@10.no-reply.drupal.org> | 2007-03-19 01:17:37 +0000 |
| commit | 259c876b296cde098b8fd80718ab492ce0286573 (patch) | |
| tree | 8fffee177ee530837013e3f7fcb606572590b74f /includes | |
| parent | 081d6d662fa2ff1b5e98eb550049e205e9c1cdd7 (diff) | |
| download | brdo-259c876b296cde098b8fd80718ab492ce0286573.tar.gz brdo-259c876b296cde098b8fd80718ab492ce0286573.tar.bz2 | |
#109513: Create temporary mysql tables in memory.
Diffstat (limited to 'includes')
| -rw-r--r-- | includes/database.mysql.inc | 2 | ||||
| -rw-r--r-- | includes/database.mysqli.inc | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/includes/database.mysql.inc b/includes/database.mysql.inc index 365bf22a6..f8eda3052 100644 --- a/includes/database.mysql.inc +++ b/includes/database.mysql.inc @@ -358,7 +358,7 @@ function db_query_temporary($query) { $tablename = array_pop($args); array_shift($args); - $query = preg_replace('/^SELECT/i', 'CREATE TEMPORARY TABLE '. $tablename .' SELECT', db_prefix_tables($query)); + $query = preg_replace('/^SELECT/i', 'CREATE TEMPORARY TABLE '. $tablename .' Engine=HEAP SELECT', db_prefix_tables($query)); if (isset($args[0]) and is_array($args[0])) { // 'All arguments in one array' syntax $args = $args[0]; } diff --git a/includes/database.mysqli.inc b/includes/database.mysqli.inc index 607da0512..3ce94c029 100644 --- a/includes/database.mysqli.inc +++ b/includes/database.mysqli.inc @@ -338,7 +338,7 @@ function db_query_temporary($query) { $tablename = array_pop($args); array_shift($args); - $query = preg_replace('/^SELECT/i', 'CREATE TEMPORARY TABLE '. $tablename .' SELECT', db_prefix_tables($query)); + $query = preg_replace('/^SELECT/i', 'CREATE TEMPORARY TABLE '. $tablename .' Engine=HEAP SELECT', db_prefix_tables($query)); if (isset($args[0]) and is_array($args[0])) { // 'All arguments in one array' syntax $args = $args[0]; } |