How many records max with MySQL ?

[fabiuz]

Hi,

for the first time I am going to store a lot of data into a MySQL database into a single table.
There are about 80.000 records to be stored and about 10 fileds of varchar type.

Could MySQL be able to menage all this data and also the Linux server could be enought to work on it ? Should I add more RAM ?

Thanks for any help about!

Fabi

[Sxooter]

Unless those records are large or have really funky data constraints, any rdbms should be able to handle 80.000 of them.

Indexing is the key to fast selects, but be careful not to index things that don't need indexing, as that will cost you during inserts and updates.

[mad27]

why don't you try it out, by filling a table with bogus test data? Then you will find out soon enough if it is still workable.
I think that it is in principle no problem, but it also depends on the load on the server. If you have a lot of pageviews in a short period of time you may get in trouble.

[[deleted]]

The hard-limits are way above what any sane person could ever need, hunderds of millions of rows.

But, at 16million rows, you shold not expect to get the same lichtning-fast response-times.