MYSQL : XML storage

2002-01-09 Thread Clive Bredenkamp 

Hi All,

I have about 15GB of xml files each ranging from about 400bytes to 4k (some
exceptions being up to a few MB, but mainly small), and am planning to stick
these files in a database for better mainteance. 

Does anyone have advice on the best way in which to import so many files or
any advice on storage structure.

Thanks,
Clive.


CLIVE BREDENKAMP
IT Dev Consultant
L@wyers Access Web
(031) 502 7630
082 3223 988


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MYSQL : XML storage

2002-01-09 Thread Mark Maunder 

Clive Bredenkamp wrote:

 Hi All,

 I have about 15GB of xml files each ranging from about 400bytes to 4k (some
 exceptions being up to a few MB, but mainly small), and am planning to stick
 these files in a database for better mainteance.

 Does anyone have advice on the best way in which to import so many files or
 any advice on storage structure.


Howzit,

You would get slightly better performance if you stored them on disk and used the
database to index them. Alternativelly you can use the BLOB datatype to store
binary data up to 64k (or the TEXT type if it is not binary). Also, check out
MEDIUMBLOB (up to 16Megs) and LONGBLOB (Up to 4 Gigs) for larger files.

As far as import options go, you can either use the command line client like so:

mysql -h mark -u root -pblah db_name  input_sql_file.sql

Or you can write yourself a neat little perl script to do it too.

~mark


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MYSQL : XML storage

2002-01-09 Thread Quentin Bennett 

Hi,

MySQL, being a relational database (quiet, you guys from other camps), is
good at storing relational data.

To store purely XML data, you may be better off using an XML database e.g.
Tomino from Software AG.

The line is a fine one, though. If your XML is purely a representation of
relational data, you may like to look at mysql -X in the latest client,
which, I believe, will produce the results in XML - I haven't tried this.

Regards

Quentin

-Original Message-
From: Clive Bredenkamp [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 January 2002 2:52 a.m.
To: '[EMAIL PROTECTED]'
Subject: MYSQL : XML storage


Hi All,

I have about 15GB of xml files each ranging from about 400bytes to 4k (some
exceptions being up to a few MB, but mainly small), and am planning to stick
these files in a database for better mainteance. 

Does anyone have advice on the best way in which to import so many files or
any advice on storage structure.

Thanks,
Clive.


CLIVE BREDENKAMP
IT Dev Consultant
L@wyers Access Web
(031) 502 7630
082 3223 988


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php