FN-FORUM: How many rows can MySQL handle?

date posted 23rd July 2007 18:36

Evening all,

Im working on a project where I would need to insert approx 26,700,000
(26.7 M) rows into one table using MySQL. I will search by two columns
(4 and 3 chars long) which will be indexed. Maximum length of a row
will be 88 chars. Result of a select query can contain multiple (max
approx 20) rows.

I am wondering if MySQL can handle such amount of records and if it
wont take ages to get the query result.

Thanks in advance.
Jay