A couple of weeks is pretty much standard to surely see a new page show up. Usually within a week, a new page will at least show up with a site: search, but it varies from site to site. Crawl rate and index rate can be very different as far as their timing. Of course, ranking anywhere in the serps for the target keyword has its own additional timeline too.