It takes almost 4 minutes to insert about 15k rows into a MYSql database via PHP, is this normal?

420_FarmAssist · 2012-05-25T23:05:23.489435+00:00

Don't use PHP is my suggestion. Just call MySQL directly with a 'LOAD DATA INFILE' command. If the data isn't in a suitable format, use PHP to pre-process the file and do the above with the result.

There are numerous other ways you could speed things up within the realm of PHP but the reality is it's smarter to not bring PHP into the picture when it isn't necessary.

shame_y · 2012-05-25T22:56:13.507027+00:00

From purely a time savings + cost standpoint, I'd suggest simply flying.

Flying PDX to SAN: $250 (~3 hrs each way)
Amtrak PDX to SAN: $395 (~30 hrs each way)
Driving 30mpg @ $4.50/gal: $330 (~19 hrs each way)

Depends on how you value your time but I think the 2 days you'd be saving would make up the difference in potential cost savings by getting a roadtripping partner. This of course isn't including food + drinks for the trip, potential mechanical problems enroute, etc.

Roadtrips are definitely awesome but expensive and it sounds like you're very cost sensitive, so I'd evaluate the benefits of driving vs flying a bit more.

soapbubbles · 1 day

http://www.craterlakelodges.com/volcano-boat-cruises-8644.html

They allow 1 boat - The one which ferries people to/from wizard island

sidcool1234 · 1 day

What's funny is if they asked someone who knew what they were doing, and enabled APC from day one, they'd have dropped it from 6 seconds to 1.5 seconds immediately. Then they probably wouldn't have spent the weeks doing all the micro-optimization.

Don't get me wrong, these are all important things to do, but it's far more important to understand the biggest bottleneck and tackle it first.

dickeytk · 2 days

This is an excellent presentation about "how to kill performance" by a well-respected PostgreSQL expert: http://thebuild.com/presentations/10-ways-to-kill-performance.pdf

See slide 28 onward. Actually read the entire thing.

dickeytk · 2 days

I'll gladly take that criticism over pandering for some points on a website.

Reddit doesn't really support useful discussion threads.. so this won't go too far.. but I've came to this 'arrogance' by getting tired of hearing the same repeated viewpoint the rails community tends to exhibit over the past few years:

OMG! I just found some_new_regurgitated_technology_that_has_existed_for_decades and it's going to change the world! Many of the ideas that the author talks about in his article are perfect examples of this.
I understand the hypocrisy here but: The general arrogance and inability to accept outsider's viewpoints that most of this community tends to promote.
The entire 'Brogrammer' mentality, which I attribute primarily to the macbook-pro toting Rails community, and to a lesser extent, the more generally more enlightened and wider Ruby community.

meritt_zare · 2 days

Yeah... I tend to say 'night' when I really mean 'evening'.

meritt_zare · 2 days

I didn't post the second photo but yes, the little guy hissed at me, and I wasn't sure, so I took a defensive posture: http://i.imgur.com/7pW1T.jpg

dickeytk · 2 days

Yes.

However with on-going forks of MySQL which phenomenally kick-ass such as Percona and MariaDB I'm not too worried about the database as a whole. Oracle will ruin it, but Percona and MariaDB will continue to do amazing things.

dickeytk · 2 days

If reddit allowed an option to post anonymously or turn off karma/upvotes/downvotes, I'd enable it immediately.

My dislike of the rails community the the current stock of "programmers" the tech bubble has enabled and nurtured has absolutely nothing to do with Reddit karma.

meritt_zare · 2 days

If you get ahold of the owner's contact info, feel free to PM me, can contact her directly if Honk is spotted again. I work from home and have two very watchful dogs that (annoyingly) alert me to every single passerby.

meritt_zare · 2 days

Yes, actually, very close. That photo was taken last night around 8pm at SW Lobelia St & SW 7th Ave. Honk was traveling southbound on SW 7th ave after posing for a photo with me.

dickeytk · 2 days

This isn't even fanboyism. This kid a fine example of your standard rails idiot.

PostgreSQL is a great open-source product but it sure as fuck doesn't need people like this as its cheerleader. Half the things he points out in here (Queueing? Are you fucking kidding me?) every seasoned database-veteran would just shake their head in shame.

meritt_zare · 3 days

Might be this one. I live really close to Taylor's Ferry & Terwilliger.

meritt_zare · 3 days

Live in SW near Lewis & Clark. Dogs were going crazy last night, a Peacock was just walking down the street. Went outside for a quick photo opportunity with him. Then he went about his business, seemed to have a destination in mind and wasn't worried nor interested in me.

Gotta love Portland.

eugene-d · 7 days

Nice effort, like to see this type of thinking.

However I have to say that simply using nginx + php-fpm + apc is going to give you basically the same feature set and speed of node.js without trying to make PHP do the event loop.

What exactly is your motivation for doing this? Just because?

systematical · 7 days

This. nginx. php-fpm. apc.

No .ini tweaks really make the amount of difference in performance as the above.

MarkusWinand · 8 days

Do you sell this in an ebook or printed book? Please link it up if you do :)

MarkusWinand · 8 days

For the record, I personally didn't vote either way on these comments. Reddit's entire up/down vote system is fundamentally flawed for the sort of reasons you brought up, among numerous others.

So was your interpretation that theoverture just mean it in a tongue-in-cheek manner? Obviously it's a colloquial expression but I feel it's a negative one to imply "This article/info/etc is useless due to <reason>" and that just pissed me off (and apparently the downvoting folks interpreted it the same).

MarkusWinand · 8 days

Yes. The statement "I stopped reading at" implies that he stopped reading because he found one mistake and implication being that the rest of the material is equally wrong and shitty information.

MarkusWinand · 8 days

He's being downvoted because he's a dick. Not because he's correct. The author has spent an enormous amount of time giving back to the programming community by authoring high quality material that's freely available to anyone to read.

MarkusWinand · 8 days

Reading books must be really difficult for you. Even extremely well respected works, such as The Art of Computer Programming, contain numerous errors. People make mistakes.

Try not to be a smug asshole about it in the future.

ffxpwns · 8 days

syntax is fine but this is a bad idea. Have an audit log instead.

timestamp | nick | balance_change | whatever else you track.

Monster-_- · 8 days

Damn the DEP and all that "counts towards your contract" crap. I was in the DEP 5 days. My IRR finally ends in 2 months though.

meritt_zare

TROPHY CASE

you'll need to login or register to do that

create a new account

login