Archive for the ‘MySQL’ Category

Preface

In November 2008 I’ve got a nice project, that resulted in a complex search engine, that specializes in clothing. I can’t give the link now, but will do when site officially launches. Key features of such service are:

  • Large number of users, which search with various parameters, rate items, leave comments, create articles etc.
  • Large database, that is updated frequently

Sure, the site is running on a dedicated server, sure I use caching, but optimal DB is a key to success.

Continue reading ‘Building high-loaded portal – InnoDB vs MyISAM’ »

Posted by Konstantin Mirin on May 20, 2009 at 09:00 under DB Design, Databases, MySQL.
Tags: , , , ,
9 Comments.

The history

In December I’ve got a project, that required sophisticated and quite complex DB and that DB was subject to change greatly during first development phase. Before that project I was using Sparx Enterprise Architect both for application design and DB design. But, frankly speaking, it’s not good at databases, especially MySQL. So I decided to pick up a new DB modelling tool.
Continue reading ‘MySQL Workbench – The Database Modeling Tool for MySQL’ »

Posted by Konstantin Mirin on March 1, 2009 at 07:42 under Databases, MySQL, Yii.
Tags: , , , ,
41 Comments.