CiviCRM Community Forums (archive)

Hey all,
Not sure if this is the right forum, but I had a quick question - I was looking into Export.php (in CRM/Export/BAO) for an unrelated query issue/bug, and I noticed EXPORT_ROW_COUNT is set to 100.  That constant is used in the queries to define the number of rows returned in the LIMIT clause.

Was there a good reason this was set to 100 rows instead of something larger?  It seems to cause more repeating MySQL queries than needed, especially on larger export sets (and each is a semi-heft query: 29-table join from what I see, but that's a separate issue).

It's not a huge deal, but our folks tend to export a lot ... I'm tempted to make that constant larger, but I'm wondering if there is a good reason not to touch it - like php memory issues?  Something else?