MySQL Forums :: Performance :: LEFT JOIN with CASE WHEN

Hate to leave things unresolved. I ended up creating a perl script that builds everything via several steps. I kept my schema the same, but used perl to step through each row of pricing and apply it to my output table running in a memory engine. 2 1/2 hours down to 2 1/2 minutes isn't too shabby of an improvement. Hopefully it will scale ok. Thanks for your help.