On Sat, Apr 27, 2002 at 05:15:10PM +1200, Sam Minnee wrote:
>
> I've been asked to put together a very large (well, it's large to
> me) database, and while mySQL is great for my current uses, I
> haven't had experience with stuff of this scale.
>
> The database will have about 88 tables, with up to 100 fields per
> table. There is a _lot_ of interlinking among the tables, and each
> "transaction" will have about 10k of data. By the end of the first
> year, almost 500,000 transactions will be in the database.
> Unfortunately, I can't be more specific, as another party is
> designing the database specification, which I don't have a copy of
> yet.
No red flags so far.
> Now, if I were to use mySQL I would want to use the transactional
> version. I haven't had any experience with this, how does its
> performance and reliability compare (obviously the transactions are
> a + to its reliability).
It's still as fast and reliable as non-transactional MySQL.
> My question is: Will mySQL be able to handle this amount /
> complexity of data well, and how much better would, say, Oracle or
> even MS SQL Server 2000 be?
MySQL will cope just fine. It'll probably be faster than the
alternatives.
> What about PostgreSQL? PostgreSQLs relationships, constraints,
> views, and stored procedures would be beneficial, but not at the
> cost of of suitable performance.
InnoDB provides referential integrity constraints ("relationships"),
so that's a non-issue. As for views and stored procedures, it's up to
you. If you need 'em, try PostgreSQL. MySQL won't have them for a
while yet.
All the databases you mentioned will work for you app. It comes down
to finding the one that has all the features you need at the lowest
price.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 79 days, processed 2,065,226,324 queries (302/sec. avg)
---------------------------------------------------------------------
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
