On 05/07/2014 17:52, Harold Hallikainen wrote:
> I've
> started on having that PHP script parse the XML and pass to MySQL, but, a=
s
> I was setting up the tables in MySql, I got to wondering about just using
> a flat file holding the XML. Though the XML is verbose, the file would
> still probably be smaller than the MySQL file with its constant field
> widths.

VARCHAR is not constant width:
http://dev.mysql.com/doc/refman/5.0/en/char.html

Data storage is 1 or 2 bytes plus the data.

David

--=20
http://www.piclist.com/techref/piclist PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.