Brian Moon had a problem - one of his cron jobs was lasting for much longer (hours!) than it should have been. He tweaked, tested and debugged the script and finally came down to a call to in_array, something he comments on as being "quite slow".
See, this job is importing data from a huge XML file into MySQL. After it is done, we want to compare the data we just added/updated to the data in the table so we can deactivate any data we did not update. [...] We then compared the two arrays by looping one array and using in_array() to check if the value was in the second array. [...] So, that was running for hours with about 400k items. Our data did not contain the value as the key, but it could as the value was unique.
He method, replacing the in_array call that had to do a full array scan for each time through the loop with an isset/unset combo on the unique key, changed the execution time down from about 4 hours to 0.8 seconds.
In the arena that night, the whole last minute was drowned out by cheers — and then when the soaring music swelled, the confetti rained down as the harbinger of balloons and the hopeful first family took the stage, forget about it — it was a perfect end to a convention that last Monday, no one even knew if it would happen. But it did, and I'm so glad to have been there.
AP - Flanked by officials from the NAACP and the Southern Poverty Law Center, FBI Director Robert Mueller last year announced with considerable fanfare a new partnership between his agency and civil rights organizations.
