Login | Register
My pages Projects Community openCollabNet

Discussions > dev [DISABLED] > Re: [PATCH] wc-ng: use TEMPORARY tables ...

subversion
Discussion topic

There will be a brief maintenance window every Friday at 17:00 Pacific.
For further details, see CollabNet's maintenance and upgrade policy.

Back to topic list

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

Author bhuvan
Full name Bhuvaneswaran A
Date 2009-10-22 11:43:53 PDT
Message 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.ti​gris.org/ds/viewMess​age.do?dsForumId=462​&dsMessageId=240​5630
>
> --
> Bhuvaneswaran A
> CollabNet Software P Ltd. | www.collab.net
>
> --------------------​--------------------​--------------
> http://subversion.ti​gris.org/ds/viewMess​age.do?dsForumId=462​&dsMessageId=240​7463
--
Bhuvaneswaran A
CollabNet Software P Ltd. | www.collab.net
Attachments
signature.asc

« Previous message in topic | 2 of 8 | Next message in topic »

Messages

Show all messages in topic

Subject
Author
Full name
Date posted
+
[PATCH] wc-ng: use TEMPORARY tables ... bhuvan Bhuvaneswaran A 2009-10-14 02:22:34 PDT
     Re: [PATCH] wc-ng: use TEMPORARY tables ... bhuvan Bhuvaneswaran A 2009-10-22 11:43:53 PDT
         Re: [PATCH] wc-ng: use TEMPORARY tables ... gavinbaumanis Gavin Baumanis 2009-10-29 17:33:30 PDT
             Re: [PATCH] wc-ng: use TEMPORARY tables ... Daniel Shahaf <d dot s at daniel dot shahaf dot name> Daniel Shahaf <d dot s at daniel dot shahaf dot name> 2009-10-29 20:00:04 PDT
                 Re: [PATCH] wc-ng: use TEMPORARY tables ... gavinbaumanis Gavin Baumanis 2009-10-29 20:34:55 PDT
                     Re: [PATCH] wc-ng: use TEMPORARY tables ... Daniel Shahaf <d dot s at daniel dot shahaf dot name> Daniel Shahaf <d dot s at daniel dot shahaf dot name> 2009-10-29 20:43:27 PDT
         Re: [PATCH] wc-ng: use TEMPORARY tables ... gavinbaumanis Gavin Baumanis 2009-11-07 01:04:03 PST
             Re: [PATCH] wc-ng: use TEMPORARY tables ... gavinbaumanis Gavin Baumanis 2009-11-13 17:21:52 PST
Messages per page: