Everything is a Freaking DNS problem - vtiger http://127.0.0.1:8080/blog/taxonomy/term/1506/0 en Using broken development frameworks , or why we don't use Zurmo http://127.0.0.1:8080/blog/using-broken-development-frameworks-or-why-we-dont-use-zurmo <p>People often wonder why DBA's used to hate developers, and with DBA's also the System Engineers,<br /> (note that I just expanded devops by adding dba's to the picture..) </p> <p>So let me tell you a story .. </p> <p>A couple of weeks ago one of our customers wanted to start experimenting with a new type of CRM. A gamified CRM.<br /> Zurmo ... </p> <p>So we set this thing up in a dev environment and started playing with it , while at first it looks nice ..<br /> the application actually felt pretty slow.. however given that is a low resource development environment we looked no further.</p> <p>Yet the next step is that we run into missing features, such as the fact that every contact you create by default is<br /> set to private .. which really isn't productive for a CRM system where you want to be able to follow up on different<br /> customer and share information. </p> <p>So we tried figuring out what the database changes to do this in bulk would mean, surely it had to be a flag on the contact record .<br /> Wrong, Zurmo uses an ORM for their database connectivity ...so their data model wasn't really trivial.</p> <p>So we decided to look at the MySQL log file to figure out what db changes happened when updating the record<br /> Yes there's better approaches but this one learned us a lot ..<br /> The procedure I followed was pointing my browser to the page where I wanted to switch the checkbox,<br /> log on to the mysql box, set global logging on . Clicked the checkbox and stopped global logging.</p> <p>This gave me a log file with all the database actions required to make that one single change.<br /> I had to cross check a number of times ... the file created by this short and small action was.<br /> about 70K </p> <p>Puzzled you start looking at the queries ...<br /> The query list was full with "SELECT * FROM " stanza's ..<br /> 70K whopping K of queries that make your hair turn grey ... </p> <p>I figured I'd file a bug .. but I couldn't find no bugtracker for Zurmo, only a forum (and forums are the most broken form of communication imvho) , yet the developers responded on Twitter.</p> <p>The feedback wasn't really satisfying so we quickly decided that supporting this application was not something we would like to do..<br /> and abandonned it.. </p> <p>The real question is who needs a <a href="http://dilbert.com/2013-05-19/" rel="nofollow">Gamified CRM</a> anyhow...</p> <p>PS. So while finishing up this article on a late evening this week I might not have put in clear enough that the generated logfile was 70Kb .. I fear some people misunderstood that it generated 70.000 queries. Obviously a huge difference. But still the log file shouldn't have been bigger han 1Kb There should have been 2-3 queries max (<a href="https://github.com/KrisBuytaert/snippets/tree/master/zurmo" title="https://github.com/KrisBuytaert/snippets/tree/master/zurmo" rel="nofollow">https://github.com/KrisBuytaert/snippets/tree/master/zurmo</a>) </p> <p>But imvho if the size of the queries you are generating is bigger than the page you are generating you are most often doing it wrong.</p> http://127.0.0.1:8080/blog/using-broken-development-frameworks-or-why-we-dont-use-zurmo#comments crm mysql opensource vtiger zurmo Wed, 10 Jul 2013 20:08:58 +0000 Kris Buytaert 1083 at http://127.0.0.1:8080/blog