Well, only use Access if it's a small project. I've used both MS SQL,
Oracle 7.3 and MySQL. My MS db is about 8 Gigs and I've only had to rebuild
damaged tables once in the last year...I just upgraded it to SQL server
2000, and it seems fine so far, as well. Oracle, I had bunches of problems
with..my db on oracle was around 5 gigs, but I got corruption like every few
months..not sure what the problem was, but I don't use oracle anymore. I've
been using MySQL for about 9 months now, for a linux project, the db is only
a few hundred megs, but i've never had problems with it yet. Speed wise, in
my projects, MS and oracle were about the same...with MySQL a little faster
than both, but MySQL can't so some of the heavier stuff that MS/Oracle
can...that's my experience with the three...it could be very different for
you, though.
jon
----- Original Message -----
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: "Chan, Kwok-Hing" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 4:24 PM
Subject: Re: Maximum Capacity and Stability
> I can't speak for the maximum capacities (but I think they are in the
manual
> or FAQ) but as to stability, I've never had MySQL crash or corrupt a
table,
> and I've been running it for several months; almost a year, actualy.
>
> j----- k-----
>
> On Thursday 08 February 2001 01:19, Chan, Kwok-Hing wrote:
> > Can anyone tell me the maximum capacity (number of tables, records) of
> > MySQL database,
> > and the stability comparison with other databases like MS Access,
Oracle,
> > MS SQL, etc.?
> > Since it is important for decision of database in my project.
> > Thank you very much!
> >
> > ---------------------------------------------------------------------
> > 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
>
> --
> Joshua Kugler
> Associated Students of the University of Alaska Fairbanks
> Information Services Director
> [EMAIL PROTECTED]
> 907-474-7601
>
> ---------------------------------------------------------------------
> 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
