> I'm not a suitable person to compare MySQL against other databases but MySQL
> will cope with this size of database if the tables are properly indexed and
> your queries optomised. Here our main database has over 90 tables and several
> of our tablse hold about the amount of data your'll acrue in year one (with many
> more rows). None of our tables have that many fields the most complex table has
> 50 fields but I don't think 100 rows will effect MySQL performance
> significantly. Several of our tables have more that 10k per row and work just
> fine.
Do you have any idea how well MySQL scales with tables containing some 10th of
million rows of data?
Cheers,
//Anders - thinking of porting
---------------------------------------------------------------------
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
