I recently switched to pig 0.9.1 and noticed it runs slower than previous version (like 0.6 which was only recent version supported on Amazon couple of months ago) in local mode. Haven't tried the timing in hadoop mode yet.
I figure it is probably due to some extra debugging or some parameter. Anything I can do to make it faster? Thanks, Dexin
