Page 2 of 2

Re: Pagination Class

Posted: Fri Oct 02, 2009 9:21 am
by josh
VladSun wrote:First, I think software developers must write high quality software (I mean "speed"), not "just-meet-the-deadlines-and-let-it-work-somehow" one (which people tend to do it via too much of abstraction and generalization). So, I can't agree with you
I was just asking if you think SQL_CALC_ROWS would save time when performance was not an issue, not whether or not developers must write speedy software ( If we're talking optimization strategies, my strategy is to attack the bottlenecks not optimize as the opportunity arises, I haven't had many speed problems other then missing indexes or poorly constructed queries, personally ).

I agree that developers should write speedy code, just not to an extreme that they spend more $ in time that they could have used for better hardware ( leisure time in life is priceless ).. I was more or less asking if you think sql_calc_rows overcomes the problems of join cardinality, and such