Re: Database back up again

[Chris Albertson <chrisalbertson90278@yahoo.com>]

--- Peter Mount <peter@retep.org.uk> wrote:
> Robert Creager wrote:
> > When grilled further on (Thu, 22 Jul 2004 19:54:36 -0500),
> > Michael Sallman <msallman@pro-ns.net> confessed:
> > 
> > 
> >>On the database problem, does anyone know if MySQL has a size limit
> on 
> >>index files? I know there are size limits/defaults on the tables 
> >>themselves (which I ran into a while back with the observations
> table) 
> >>that can be tweaked, but I haven't found anything on the index
> files.
> >>It would probably make sense to break up my observations table
> (which is 
> >>now 8.9 gigs in size) into several smaller tables. But then I'd
> have to 
> >>re-code all the database queries. :-(

Absolutly don't do that.  IF there is a size limit switch to
a different DBMS.  There are many that don't have this problem.

Not only will it make your querries harder to write but someone
else might want to write applications to querry the database.

I anyone's short list of bad design ideas some place above
"keeping the same information in more than one table" is
"having to know which table to query based on the table
content" In theory such a database can't be querried using
SQL.  You would have to use some logic in a procedural language
outside of the SQL.  Making many 3rd party package unusable
(like say MS Excel with ODBC or MS Access)


=====
Chris Albertson
  Home:   310-376-1029  chrisalbertson90278@yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson@aero.org
  KG6OMK


		
__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail