mysql max entries?

i wonder how many entries a mysql table can take without having an excessive delay to search inside this table

let imagine this question for an average table, 4 to 6 fields
and an average server with linux, 1go RAM

any idea of the maximum (approx of course)?

thanks!

 

(and using PHP to use and search an entry from this table)

 

This can depend on one or more of the following:
Size of the data
Spread of your data
amount of records (logical)
type of query performed
indexes
applicability of the available indexes
your mysql server
your mysql tabletype

The only way to know is to test and to measure for you specific enviroment.

 

yes i know, but i want just an idea, based on average parameters

thanks

 

I am sorry any answer you get would not give you any advice for your scenario. They would give advice based on their scenario and any variation can give you other results.