.
Baroda - 390007
Gujarat, India
Personally I'm always ready to learn, although I do not always like being taught
From: Gavin Towey
To: Sudhir N ; Mysql
Sent: Tue, 15 December, 2009 2:16:53 AM
Subject: RE: Optimization suggestions
Id should probably
Id should probably be an auto_incrementing INT, if you still need a unique text
identifier, then I would make a separate field. Though my opinion isn't the
only way; there is much debate on natural vs. surrogate keys.
I would normalize "folderid" into a lookup in another table, and make folderi
After one very quick look, the index on folderid alone is unnecessary since
you have another index in which that field is the high-order field.
On Mon, Dec 14, 2009 at 12:31 PM, Sudhir N wrote:
> I have following table structure, I have to use merge storage engine.
> Please have a look, and prov
Please see my comments below :
On Thu, 2005-12-01 at 14:06 -0600, Ross Anderson wrote:
> I have read the suggestions for optimization for innodb however I'm
> curious if anyone can help me understand which buffers are common (thus
> used by innodb action) and which are specific to myiasm. The s
