http://bugs.gpodder.org/show_bug.cgi?id=259
--- Comment #4 from Cory Albrecht <[EMAIL PROTECTED]> 2008-11-25 17:26:21 --- (In reply to comment #3) ...snippage... > Justin, Cory: What do you think? Does this sound valid to you? Very well thought out, I think. My only queston is WRT the complexity of the SQL statement. I tend to work on smaller projects where the optimization gains from combining multiple steps into one step are insignificant and thus it's worth my sanity to separate things into smaller steps that are easier to follow and debug. What would the performance hit be if first you did a SELECT COUNT(*) FROM episodes WHERE guid=? and put that count in a variable and then have an if-then to choose between "WHERE guid=? and url=?" and "WHERE guid=?" for a second call to sqlite? Of course, that's really more of a stylistic thing on how individual programmers write their code. When you decide on a patch, I will be more than happy to test it with my situation. -- Configure bugmail: http://bugs.gpodder.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes. _______________________________________________ gPodder-Bugs mailing list [email protected] https://lists.berlios.de/mailman/listinfo/gpodder-bugs
