A similar discussion happening on Request: 512 memory
For very intermittent or low scale apps it’s possible to do to the lowest tier of CPU and still provision and pay for just the extra RAM you need, if the base 128MB is not enough.
The autoscaling options: Scaling and Autoscaling can also help add more instances automatically if necessary.