Silly Question I Think

[smoky989]

I am running a website for a hockey league I am in and I want to keep track of the stats. I have no problem with the PHP programming or mysql databases.

I want to keep all time stats and with a potential 2000 entries per season (3 seasons per year) the entries will add up over time. The stats will be entered along with a player id.

Now if I have a page for a player and it has to search 20,000 entries, will that slow down the page and script significantly? I would strongly imagine no but I'm not really sure the limitations of mysql databases.

Thanks for your thoughts

 

[vacunita]

20,000 entries should pose no problem for a mysql database.
Or the PHP script calling the search.

Mysql is capable of handling millions of record and thousands of queries at a time.




----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.