[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: [PATCH] wc-ng: use TEMPORARY tables ...

From: Gavin Baumanis <gavinb_at_thespidernet.com>
Date: Sat, 7 Nov 2009 20:03:57 +1100

Ping. This patch submission has received no comments.

Gavin.

On 23/10/2009, at 05:43 , Bhuvaneswaran A wrote:

> Greg/Hyrum: ping?
>
> On Wed, 2009-10-14 at 14:52 +0530, Bhuvaneswaran A wrote:
>> Hello,
>> As discussed in this email thread [1], please find attached the
>> patch to
>> use the TEMPORARY table when we want to remove columns from wc-ng
>> related tables, and reduce number of SQLs by not creating the
>> TEMPORARY
>> tables explicitly.
>>
>> [[
>> Use "CREATE TEMPORARY TABLE table_name AS SELECT" sql syntax to
>> create
>> temporary table, while dropping columns from the original table.
>>
>> * subversion/libsvn_wc/wc-metadata.sql
>> (ACTUAL_NODE_BACKUP): Define as temporary table. Use "CREATE
>> TEMPORARY
>> TABLE table_name AS SELECT" syntax, instead of creating the table
>> explicitly.
>> (BASE_NODE_BACKUP): Use "CREATE TEMPORARY TABLE table_name AS
>> SELECT"
>> syntax, instead of creating the table explicitly.
>> ]]
>>
>> [1]
>> http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=2405630
>>
>> --
>> Bhuvaneswaran A
>> CollabNet Software P Ltd. | www.collab.net
>>
>> ------------------------------------------------------
>> http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=2407463
> --
> Bhuvaneswaran A
> CollabNet Software P Ltd. | www.collab.net
>
> ------------------------------------------------------
> http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=2410355

------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=2415365
Received on 2009-11-07 10:04:26 CET

This is an archived mail posted to the Subversion Dev mailing list.