On Sun, Dec 14, 2003 at 03:53:00PM -0500, Dan Anderson wrote: > > I have a database I'm using for a MMORPG (well, it isn't very > MM because I'm something of a noob), and I have a few questions about > indexing. I am storing world data in a database. In order to keep > everything as swift as possible, I have indexed everything. And I > really mean, everything -- a few dozen columns on a half dozen tables. > > My question is, is this the right way? I figure that since
Not necessarily. You should analyze your SELECTS individually and create the indexes that are going to be used. You may also see where multi-column indexes could give you even more speed if you do this (you might be able to benefit from 'using index' to pull all rows from an index) The only other thing you should be worried about is the size of the indexfile; bigger indexfiles take longer to seek through; but since you say they'll all fit in mem this is only a concern when you're going to be updating them I suppose. With such a small database it really boils down to just being tidy; you don't want indexes you're not going to use. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
