added local regions to redis and moved more customer queries to prepared statements on compile