Having success with 20 million rows

2001-05-09 Thread David J. Potter
Just wanted to say that we are having success using MySql. Even though our tables are large, over 20 million rows, selects, updates and inserts occur very fast. We use both Windows and Linux. Adding a column is the only action that is slow (it took 4 days once to add a column), but that is

Need guidance regarding constant table corruption

2001-02-08 Thread David J. Potter
Hello, Until recently I have spent most of my time using the major databases such as Oracle, DB2, Sybase etc. I am new to MySQL. At first I was excited about such a low cost alternative such as MySQL, and I have found Mysql to be a great database for very small databases, but for large