SQLite 3.8.7 is 50% faster than 3.7.17

Re:SQLite 3.8.7 is 50% faster than 3.7.17 by zamalek on Tuesday October 07, 2014 @10:10AM (#8421181)

Indeed. However, keep in mind that as this beginner "ramps up" to the knowledge level of someone who is working on a SQL database he will need a source to find out where costs lie. He's done some profiling, finds an expensive method with massive amounts of string concats, heads to Google and all he can find is "don't prematurely optimize."

You can supplement an answer with "don't prematurely optimize," but the presumption that premature optimization is occurring is a premature assumption.

He who asks a question is a fool for five minutes; he who does not ask a question remains a fool forever. ~ Chinese Proverb

I would work with beginners that are not fools, than experts who are.

[ Parent | on HN ]

Re:SQLite 3.8.7 is 50% faster than 3.7.17 by sosborn on Tuesday October 07, 2014 @01:33PM (#8422561)

> He's done some profiling

In my experience on Stack Overflow, the people getting hit with accusations of "premature optimization" have not gone this far.

[ Parent | on HN ]

Re:SQLite 3.8.7 is 50% faster than 3.7.17 by marcosdumay on Tuesday October 07, 2014 @10:56AM (#8421505)

Nope, if he got to that level, he'll know that the only way to really know it is testing.

He may still ask why one is slower than the other (if it is, I don't know that), but that's a completely different question that in most contexts will get a nice answer.

[ Parent | on HN ]

Re:SQLite 3.8.7 is 50% faster than 3.7.17 by bunderbunder on Tuesday October 07, 2014 @12:12PM (#8422007)

Suppose, for a moment, that our hero is seeing this situation for the first time and doesn't know what the alternatives are.

Tests that don't cover the best option can't possibly identify the best option. So if you want to do a really good test, going somewhere to ask, "What else should I try?" is hardly an asinine course of action. On the contrary, if our hero is new to this stuff, or is new to the platform in question, or anything like that, then asking others for advice should probably qualify as due diligence.

[ Parent | on HN ]