If it is too fine you'll have a problem sucking up the waste without removing your sand. If it is cheap and you aren't sucking all of it up then that might be OK, you can just periodically top up what you lose. You definitely want to keep the cleaning as easy and straightforward as possible.