Tips for designing an effective databases

I am starting a high end complex project which will have an online and offline module.

Can someone list down the techniques to be kept in mind to ensure a speedy db - such as using INNODB tables , putting indexes on searchable fields and so on.

start by reading the big bad sticky thread at the top of this forum :smiley: