From 259c876b296cde098b8fd80718ab492ce0286573 Mon Sep 17 00:00:00 2001 From: Steven Wittens Date: Mon, 19 Mar 2007 01:17:37 +0000 Subject: #109513: Create temporary mysql tables in memory. --- includes/database.mysqli.inc | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'includes/database.mysqli.inc') 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]; } -- cgit v1.2.3