Hi Paul,

Is it any problem for future update ?

Example:Our board still 3.5.4 but I'll update to 3.6.0 when it is available.

Because I have a 240.000 member and 2.000.000 + messages.I have no load problem, but yes sometimes search IP peak up our server.

This trick delete all IP's or only move other tables ? I'm already running fulltextsearch.


Thanks

How can I delete the stored IP addresses from only the last 6 month ago, or isn't it possible? Perhaps this would speed up the creation of the index.

Anyone? :(

Just add the index, no need to shut down anything, and it's fine in any vb version.

Thanks again, it works great!

Would it make sense to add an second index to the table "USER", since this table also contains many ip addresses? Right now no index for "ipaddress" is defined in "USER".

You could, but it's not so important, that field is not used much, even in ip searches (and then only in vb 3.5 / 3.6).