Performance improvement for xml loads (+comments)
Derek Atkins
warlord@MIT.EDU
07 Dec 2000 16:03:56 -0500
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 <spinler.patrick@mayo.edu> 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: Spinler.Patrick@Mayo.EDU
> Mayo Foundation phone: 507/284-9485
>
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel@lists.gnumatic.com
> 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
warlord@MIT.EDU PGP key available