Imporving my database



I am trying to increase my DB speed because its it so big it has gotten very slow, I will be this by indexing the large tables,

my issue is that i am getting it wrong with the correct syntax and need your help, shown below is an example of what i am trying to do.

name VARCHAR(32),
dob DATE,
unique INT, INDEX (id)

after the table is created.
To add an index to an existing table, the following would be used.

ALTER TABLE people (
ADD INDEX id(unique),
ADD INDEX name(name);

But I cant seem to get the syntax right when i try to this with the piwik DB, I am trying to index resource hungry tables,

can you show me the correct syntax and the suggested tables to attack please.

kind regards



(Matthieu Aubry) #3

Hi Philip,

it seems a question unrelated to Piwik so I don’t know what to say.


what do mean, I want to apply indexing table to piwik database.