Hello, i've got a problem with mydac. I'm woking wih big tables and a need to reindex that. I suppose to use an alter table query for delete old index and add new one. MyDAC tell me a Lost Connection during query.
This is my query:
ALTER TABLE `mydb`.`a` DROP INDEX `a`,
ADD INDEX `a`(`a`),
DROP INDEX `b`,
ADD INDEX `b`(`b`),
DROP INDEX `c`,
ADD INDEX `c`(`c`)
, DROP INDEX `d`,
ADD INDEX `d`(`d`);
Rows on mydb.a: 617747
The query on my system takes about 25secs
Delphi 2005 update pack 2
MyDAC 3.50.0.18
Any suggestion?
Lost connection on alter table ... create index
-
- Posts: 5
- Joined: Tue 08 Mar 2005 12:07