Brett,
I am using mysql to log RADIUS accounting for a big ISP.
The accounting table has 10 fields of different types with one index on an
aggregate of 3 fields. The record is fixed length.
Mysql is reasonably fast and handles tables until you reach the 2 GB file
size limit where it fails (this
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'
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 tr
