Archive for the ‘DB Design’ Category

The database structure

In the previous post I outlined the system’s specs and use cases. We also selected the primary use case we should start from – that is filtering screen.

Continue reading ‘Database structure and filtering approach. SMS Notification system.’ »

Posted by Konstantin Mirin on March 19, 2010 at 08:00 under DB Design, Programming.
Tags: , , , ,
13 Comments.

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.