Bryan,
You've given no indication of what "this structure" is - the fact that
your data is rarely read or updated will have little bearing on whether
an RDBMS is suitable for your needs. It would be a very rare case,
however, where a simple flat text file gave you quicker access to a search
of a set of data than would a well-indexed (or even
non-indexed!) database table - *especially* a text file which needs to be
expensively parsed before any searching can be effective (ie an XML file).
Shall I have another rant about this year's buzzwords ? Don't assume that
a word you hear being thrown around will be the solution to every single
one of your IT problems. XML really is most useful where two parties need
a common format for the exchange of data - there are very few situations
where general storage of data in an XML format would be advantageous over
other 'traditional' methods.
regards,
P
On Wed, 21 Mar 2001, Bryan Coon wrote:
>
> 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
