Can you let me know a bit more about what this is going to do? How does it speed it up, and why will I need more disc space (i'll have to ask the board owner about that one)?
Well, the post table is huge, usually the biggest in your vB database. If there is no index on the IP field, the query will have to search the entire post table, without an index. If you add an index by IP address, it will know where to look for, as they are already mapped. This will speed the IP search significantly. Without an IP index, your search will be slower as the post table gets bigger.
The disk space is required whenever you add an index, since the index will need to be stored on the hard disk. It will take a percentage of the size of the post table, so it's not too big (not bigger than the actual post table)
07-19-2005, 10:24 PM
Threaded Mode