TechNote (Archived)

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

Issue

---

When indexing data from a database query, the maximum number of rows that can be indexed from the query is 65,520. Attempting to index more than 65,520 rows will appear to succeed, as no error is reported. However, the additional rows will not be indexed. This has been identified as Macromedia issue 60811.

Solution

---

If more than 65,520 rows need to be indexed, split the original database query into two or more smaller queries.

Search Support

---