This table contains more than 2.5 million records. I
created index on column hari. It needs more than 3797
secs, and have not finished yet.
Anybody has advice?
mysql describe tb_trafik_bulanan;
+---+--+--+-+-+---+
| Field | Type
It is not that mysql it slow, its your database design and the fact you have
2.5 million records in the table.
It is not clear from your description of the problem what you are trying to
do, so giving advice is that much harder. If you are creating an index on
the column hari, it will take a
-
From: "Muhammad Ilhami" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 12:41 PM
Subject: mysql is really a slow rdbms
This table contains more than 2.5 million records. I
created index on column hari. It needs more than 3797
secs, and have not fi