Demo file: found-set-to-json-object.zip (40MB; requires FM 18 or later)

[Author’s note: the demo file is a work in progress. Modify it as you see fit.]
Today we’re going to compare various methods one might consider employing to render an arbitrary found set as a JSON object. The demo consists of a table of US customers with 250K records, and the JSON object will be structured like so…
{
State Name:
{ County : [ [ customer array ] , [ customer array ] ... ] ,
County : [ [ customer array ] , [ customer array ] ... ] ,
...
} ,
State Name:
{ County : [ [ customer array ] , [ customer array ] ... ] ,
County : [ [ customer array ] , [ customer array ] ... ] ,
...
} ,
...
}
…i.e., grouped by state name and county, with customer data represented as a two-dimensional array, for example: Continue reading “Render Found Set as JSON Object” →