Brett,
Regarding large tables in mysql, I am using tables with 20 million rows+ and
it works just fine. The tables only have two columns. The first is
varchar[50] and the second column an int type.
Regarding speed of access to the data, selects like "select field1 from
table1 where field1='abcd';" work very quickly. Selects using like also work
quickly when in the format: "select fields1 from table1 where field1 like
'abcd%';". What is slow is selects of the format : "select field1 from
table1 where field1 like '%abcd%';"
As for updates I haven't done much of that so I cannot comment on the speed.
Michael Thomas
www.abcxyz.com
-----Original Message-----
From: Brett Paden [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 6:13 PM
To: [EMAIL PROTECTED]
Subject: examples of large mysql databases
I have been using mysql for many years and have failry reliable
web-based applications using tables with 3 million+ records.
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). 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. We are very
happy with the functionality and flexibility of mysql, and don't need
RDBMS features like transaction management, triggers, or stored
proceedures.
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.
Thanks!
--
Brett Paden
[EMAIL PROTECTED]
http://www.trimeros.com
---------------------------------------------------------------------
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
