Re: Performance improvement for xml loads (+comments)

[Derek Atkins]

But this is just the same as:

        account_tree = load_file_version_1(filename);
        save_file_version_2(filename2, account_tree);

You're not making an extensible format, you're changing the format
of the data.

-derek

Patrick Spinler <[EMAIL PROTECTED]> writes:

> Ayup - snipped from the postgresql manual:
> 
>   Name
> 
>      ALTER TABLE -- Modifies table properties
>         
>   Synopsis
> 
>   ALTER TABLE table
>       [ * ] ADD [ COLUMN ] column type
>   ALTER TABLE table
>       [ * ] RENAME [ COLUMN ] column TO newcolumn
> 
> Also, speaking from experience, it's generally pretty trivial to save a
> table, recreate it, and reload it from the save. E.g.:
> 
>   create table foo_save as select b, c from foo;
>   drop table foo;
>   create table foo (new_a char, changed_b int, c date);
>   insert into foo values select 'filler', int (b), c from foo;
> 
> I do this a lot in the database projects I'm a dba for at work.
> 
> -- Pat
> 
> 
> -- 
>       This message does not represent the policies or positions
>            of the Mayo Foundation or its subsidiaries.
>   Patrick Spinler                     email:  [EMAIL PROTECTED]
>   Mayo Foundation                     phone:  507/284-9485
> 
> _______________________________________________
> gnucash-devel mailing list
> [EMAIL PROTECTED]
> http://www.gnumatic.com/cgi-bin/mailman/listinfo/gnucash-devel

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/      PP-ASEL      N1NWH
       [EMAIL PROTECTED]                        PGP key available

_______________________________________________
gnucash-devel mailing list
[EMAIL PROTECTED]
http://www.gnumatic.com/cgi-bin/mailman/listinfo/gnucash-devel