<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>hey sergio,</div><div><br></div><div>if objects and tables with relations where truly comparable, <a href="http://en.wikipedia.org/wiki/Object-relational_impedance_mismatch">objet-relational-impedance-mismatch</a> [1] would not exist.</div><div><br></div><div>In the other hand if you use a BTree of objects indexed in the way you need, your speed will have no match in the RDBMS world.</div><div><br></div><div>Proper use of Gemstone, omnibase or even a modest index persisted in the image (a facade to a BTree or something like that) will satisfy quite high expectations.</div><div><br></div><div>Have in mind that, for performance, the only metric that really counts is the user experience.</div><div><br></div><div>Maximize anything else and you'll be heading to a non human centered artifact, faster.</div><div><br></div><div>BTW, this could be off topic but in the economy there is an anti-pattern familiar to this when you see companies maximizing profit instead of wealth creation.</div><div><br></div><div>for more I highly recommend this video:</div><div><br></div><div>Re-thinking IT by John Seddon</div><div><a href="http://vimeo.com/19122939">http://vimeo.com/19122939</a></div><div><br></div><div><a href="http://about.me/sebastianconcept">sebastian</a></div><div><br></div><div>o/</div><div><br></div><div>[1] <a href="http://en.wikipedia.org/wiki/Object-relational_impedance_mismatch">http://en.wikipedia.org/wiki/Object-relational_impedance_mismatch</a></div><div><br></div><div><br></div><div><br></div><div><div>On Dec 3, 2011, at 3:56 PM, sergio_101 wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>i am currently developing an app just for fun..<br><br>during my day job, i am a developer using a web framework that<br>directly connects to a database (mysql)..<br><br>one of the things we always do is craft our queries to use use the<br>database only for all queries and selections. when you use the<br>database for anything other than trivial queries, the difference is<br>the speed of the query is totally evident..<br><br><br>i am just wondering how the speed of the smalltalk VM compares to the<br>speed of pulling results from a database and shoving them into an<br>array..<br><br>thanks!<br><br>-- <br>----<br>peace,<br>sergio<br>photographer, journalist, visionary<br><br><a href="http://www.CodingForHire.com">http://www.CodingForHire.com</a><br>http://www.coffee-black.com<br>http://www.painlessfrugality.com<br>http://www.twitter.com/sergio_101<br>http://www.facebook.com/sergio101<br>_______________________________________________<br>seaside mailing list<br>seaside@lists.squeakfoundation.org<br>http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside<br></div></blockquote></div><div><br class="webkit-block-placeholder"></div><div><br class="Apple-interchange-newline"><br class="Apple-interchange-newline">
</div>
<br></body></html>