Hello Everyone, Just wanted to suggest an improvement and let everyone know how to fix an issue.

The Problem:
You have a lot of orders and a lot of customers using the system and one day you get a 500 error trying to log into your admin system.

Why is this happening?!:
After a couple hours of trying to figure out which script was the problem I found it was the update mechanism in the store/admin/includes/extra_functions/reward_points_functions.php file. The query that updates the points was taking ~a minute to execute. Whew - I found the problem.

Great now how do I fix it?:
Simple actually. Add an index to the reward_status_track table. My table prefix is zen_ so your query may differ - here's mine
ALTER TABLE `zen_reward_status_track` ADD INDEX ( `customers_id` )

Now the query takes ~.003 seconds - Hooray!

Thanks again for this awesome zen cart add on and I hope my frustrations help someone else avoid a trip down the rabbit hole to debug this.