[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, 14 Nov 2009 12:21:46 +1100

I have logged issue ; 3527
http://subversion.tigris.org/issues/show_bug.cgi?id=3527

Gavin.

On 07/11/2009, at 20:03 , Gavin Baumanis wrote:

> 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

------------------------------------------------------
http://subversion.tigris.org/ds/viewMessage.do?dsForumId=462&dsMessageId=2417824
Received on 2009-11-14 02:21:58 CET

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

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.