Hello!
Having a pretty old laptop as my primary development workstation, I'm very concerned about development speed. Under development process I mean the most frequent operations you do when making a website, like:
- installing and configuring modules
- creating and configuring entities (nodes, products) and fields
- theme development
While measuring and boosting performance of Drupal websites for users, engaging different techniques and tools to speedup things for anonymouses, nobody seems to think about ourselves - the developers. At that, InnoDB, which was adopted as the default database engine for MySQL DB backend, seems to be no good at all.
Please read this post: http://drupal.org/node/1661608
What do I mean is the database usage when in development differs from the usage when in production; therefore tuning practices are different.
I suggest to share practices you use to speedup development.
So my first cents: switching back to MyISAM might and would probably bring noticeable performance boost in development process. In my case, it speedups things for about 100-200%.
Comments are welcome!
best
Artiom
P.S. After saving this post I felt unease about the subject is not coherent with the body. Well, sorry for that. I had been looking for some benchmarking tools which would help me to verify my assumption on MyISAM dwarfing the InnoDB, when found this group. Unfortunately I didn't find any descriptions of approaches on how to measure Drupal administrative UI. If you know one, please share.
Comments
http://drupal.org/node/166160
http://drupal.org/node/1661608#comment-6177108