![]() |
adding index to posts table for ip search
IP search crushes my database. I heard adding an index to the posts table does the trick. How do I do that? thanks!
|
I'm not a mysql expert, but I think you'd want to add an index to the post table on column ipaddress. If you have phpMyAdmin, you can click on the database then the post table, then "structure". Find the "+index" link and click it, then where it says "Create an index on 1 columns", press go. Then enter a name (like ipaddress), select INDEX from the dropdown, and ipaddress from the other dropdown.
If you want to do it via a query, I think it would be Code:
CREATE INDEX ipaddress ON post (ipaddress) I also should mention that I'm not sure what effect adding that index will have, because of course any index takes up storage space and has to be maintained which means that every time anyone posts it has to update that index. I suppose posting happens much less often than displaying posts, so maybe it's not an issue. |
All times are GMT. The time now is 10:22 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|