Modification to IP Searches
 

Is there a way to possibly modify the IP search to only search the last 30 or 60 days of posts (instead of the past 4 years in my case)? With a little over 5.2 million posts, searching IP addresses normally crashes the server (or brings it pretty close). Normally when I need to do an IP search the past 30 or 60 days is sufficient to track down the person with more than one account.

Thoughts?

Why not try adding an index to the ip field in the post table ?

Yup, adding an index to the IP will solve most problems:
[sql]ALTER TABLE post ADD INDEX ipaddress(ipaddress ASC);[/sql]

Strange that there is no index on that field already... is there a reason why there wasn't an index on that field to begin with?

Seems that Jelsoft is a bit conservative on index usage. They tend only to use primary keys to reduce storage and access time when updating tables.