I'm sure he means for you to go back to the archives and beat the horse on
your own.
flat files are only useful for 1-on-1 relationships. A simple example. You
have a student record and each student takes several subjects in which you
keep results and other info for. You can do a flat file for it, but geez,
it's very inefficient, wastes a lot of space and prone to errors.
----- Original Message -----
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: "'Eric Fitzgerald'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 22, 2001 8:48
Subject: RE: MySQL and XML?
>
> What are the advantages of flat files? I am having no speed issues at
> all... in fact Im quite happy to stay with MySQL. But my boss is loaded
> with ideas you see, so I have to be able to justify why mysql is better
than
> flat files.
>
> Thanks for the response, feel free to kick the dead horse one more time :)
>
> Bryan
>
>
> -----Original Message-----
> From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 21, 2001 4:43 PM
> To: Bryan Coon; [EMAIL PROTECTED]
> Subject: Re: MySQL and XML?
>
>
> Well list, I think we have a new weekly dead horse to with which to use
our
> sticks on :)
>
> To answer your question, no, XML is not being added currently to MySQL.
> Flat files have some advantages, but have to be implented well to work
well,
> you can't just open the whole thing and scan through it looking for what
you
> need. MySQL is fast, very fast. If your current implentation is having
no
> speed issues, then don't fix what isn't broken. If you are having speed
> issues, I would suggest you give us some examples of your table layouts so
> that we can see if maybe you have some innefecient key usage.
>
> ----- Original Message -----
> From: "Bryan Coon" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, March 21, 2001 2:23 PM
> Subject: MySQL and XML?
>
>
> >
> > Can anyone offer some insight into the following topic?
> >
> > I would like to provide web access to search a large database of
> > information. Currently, I am using MySQL to do this, and it works
great.
> > However, this database is almost entirely static, there are virtually no
> > inserts or updates done.
> >
> > For accessing information with this structure, is an RDBM the most
> efficient
> > way to search through this information? I know Oracle has been modified
> to
> > use XML files as the database, making queries directly to a flat file
> > (although I have not seen it in action).
> >
> > Does MySQL support anything of this nature, or is anyone working on any
> > module along these lines? What is the advantage for using a flat file?
I
> > am fairly new to this kind of thing, I would like to learn more.
> >
> > Thanks!
> >
> >
> > ---------------------------------------------------------------------
> > 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
> >
> >
> >
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
