Login | Register
My pages Projects Community openCollabNet

Discussions > dev [DISABLED] > [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

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

Author bhuvan
Full name Bhuvaneswaran A
Date 2009-10-14 02:22:34 PDT
Message 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
Attachments
wc-metadata.diff
signature.asc

« Previous message in topic | 1 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: