Imporving my database


#1

Hi,

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.

CREATE TABLE people (
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
Phillip


#2

anyone?


(Matthieu Aubry) #3

Hi Philip,

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


#4

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