On Fri, Jan 19, 2001 at 08:12:49PM -0600, Brett Paden wrote:
> I am curious as to other people's experiences with larger amounts of
> data, like 5 to 50 million record tables (I am assuming each record
> has dozens of columns of various datatypes).
~35 million records in one table without any troubles. But the rows
don't have nearly that many columns. In fact, the big one has 9
columns in it.
> We are looking into switching to Oracle simply to handle the size of
> our data, but are wondering what other people's experiences have
> been.
If it's just a size issue, how will switching to Oracle help? The size
is typically limited by your OS and hardware.
> We are very happy with the functionality and flexibility of mysql,
> and don't need RDBMS features like transaction management, triggers,
> or stored proceedures.
All the more reason not to switch...
> I am new to the list, so if there are existing threads on this topic
> I should be reading, please let me know what subject headings I
> should search on.
It has come up in the past, but I don't recall the particular threads.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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
