I may or may not be needing to worry about this anymore but I couldn't figure it out so I think it would be good to get some input from people.
If you need to store a bunch of information about something, and you're storing millions of individual records, what's the best way of implementing this so the PHP pages don't take forever to process(forever being, half a second or so, since I would be expecting a lot of trafic).
More specificly, I was going to make an item system in an online game where there could theoreticly be millions of different items, each having their own stats and they would all need to be stored in a way where I could quickly find which items belonged to the player logged in at the time. The problem was one big table obviously wouldn't work and the only other methods I thought up were arbitrarily dividing them into tables each holding 10,000 items. This seemed pretty kludgy though, and I'm sure there are some better ways.
So, maybe someone who's had experience with large databases could gimme some insight? thanks