```json
{
    "title": "Re-write of GrabPERF Data Insertion Process",
    "url": "https://performancezen.com/2005/01/18/re-write-of-grabperf-data-insertion-process/",
    "datePublished": "2005-01-18",
    "dateModified": "2005-01-18",
    "language": "en-US",
    "description": "I re-wrote the data inserting mechanism for the GrabPERF script. Previously, I had been looping through the measurements, then looping through the results to insert them. Now I open two…",
    "author": "spierzchala",
    "publisher": "Performance Zen"
}
```

# Re-write of GrabPERF Data Insertion Process

I re-wrote the data inserting mechanism for the GrabPERF script. Previously, I had been looping through the measurements, then looping through the results to insert them.

Now I open two database connections, loop through the measurements and insert them after the data is collected. Much more efficient, although I am still a hack programmer.

I will be glad to share a sanitized version of the measurement script with anyone who asks.