初学者PHP / mySQL问题

Question

I'm brand new to PHP & MySQL, and one function I'm creating needs to access a large table or database. I've created the database and it's currently in a MySQL table, which I'm accessing with no problem. The table is 11,000 rows in length, with 8 columns (all text less than 8 characters long) - it's static, and will never change. Without getting too particular, my users will hit a button which will trigger scripts to access the data, say 500 times or more. So in general would it be better practice to include all of this data in a big 'switch' or 'if... then' conditional right in my scripts, rather than opening and accessing the database connection hundreds, or maybe even thousands of times? It just seems like that might be a bottleneck waiting to happen. Thanks!

Answer 1

In your case I'd keep the database but load the entire contents into memory (array) at the start of the script. If you want to optimize later on you could use a very simple lazy loading scheme, reading a batch of data on requests. Perhaps there are hints on what rows may be requested. But keep it simple!