111–120 of 195 posts
Earlier quoted context omitted.
Last week I optimized some MySQL queries which triggered the 'not-using-index' warning, even when I had all fields which were used for selecting and sorting indexed. I think a JOIN on a nested subselect somehow confused MySQL: when I duplicated some extra restraining WHERE clauses into the subselect, response shot up from 800msec to 12msec per query. Very nice. But the query still shows up as 'not-using-index', which…
MySQL's query plan is odd at times. What does an explain look like on that query? If any portion of the query, including subselects isn't able to use an index, it will report it. You can try to force indicies with USE INDEX/FORCE INDEX which can sometimes help.
Heh, I was wondering what this was when I first saw it a few hours ago. I've seen 5-6 people I follow on Tumblr use this thing already. I suggest migrating it to Heroku. Push your code, copy over the database, and crank your dynos up. They charge by the hour, so as an example if you have ~10 dynos running (roughly equivalent to 10 thin instances, but slightly better) for 5 days (or however long it takes for the initi…
There's a bit of magic involved with things like compass/sass and Paperclip on Heroku (you have to use Amazon S3 for storage and there is some other setting I can check on). Anyway Mark, I have a bunch of apps on Heroku that use all kinds of wacky stuff—including the aforementioned gems—so email me at jarin (at) robotmodehq.com if you decide to try out Heroku and get stuck. I can send over working code snippets that…
About monetizing: you could show the first 2 words only, and charge a small fee for the third ? I guess people would pay to see what is said about them at least.
I don't suppose this traffic will sustain. Slap an ad right in the center and monetize the hell out of it. Or get a sponsor. Also, for the short term, Amazon EC2 would be the best option to handle the traffic.
http://markbao.com/about You're 17/18? Kids these days. Geeze. Fine work sir, though I don't have much advice to offer beyond what has already been stated.
Yeah, and I met Mark 3 or 4 years ago and he had already started at least one and maybe 2 successful startups.
Adsense. With only about 10k hits a day, my bedtime calculator http://sleepyti.me brings in $10-$20/day. At the rate you're getting users, you could probably bring in a significant load of cash. Good luck!
Depends on the niche and the website. I have made a blogspot blog and brought it to 4% CTR and $20 CPM. That's +$200 a day.
FYI: Heroku is fantastic for scaling apps. But if it's your database that's the bottleneck...you've got problems. Because your options with SQL are scaling up or sharding, each quite painful. If you want any advice, ping me.
As a DB they say it's designed for SPEED and SCALE. It might be worth looking at. (who's got the time right?) :)
Earlier quoted context omitted.
>To be fair, Reddit has a noted capacity for charity and generosity Understatement of the year.
>Understatement Entirely necessary here, even a hint of hyperbole and the pedants come out of the woodwork.