A new technote was released yesterday concerning Verity:

ColdFusion MX 7: Verity custom collection indexing limit of 65520 rows

If you are indexing huge record sets, this will apply to you. Of course, do not forget that CFMX Standard has a limit of 125k records per box, and CFMX Enterprise has a limit of 250k records. That is per box - not just collection. Of course, if your records are that big - you are probably a candidate for the full Verity solution, and you can still use ColdFusion with it of course.