Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Performance » MySQL » Improving time for creating indices in MySQL ?
Improving time for creating indices in MySQL ? [message #3676] Wed, 29 October 2008 10:59 Go to previous message
afflictedd2 is currently offline afflictedd2
Messages: 4
Registered: July 2008
Location: Texas
Junior Member
Hi guys I have been working on a program that will populate and index a database. The populating doesn't take too long, but the indexing does. My question is: Is there a better approach to indexing this table than the one I'm using right now?

I'm doing this through QtSql.

for (int i = 0; i < headers.size(); ++i) {
q.exec("ALTER TABLE temptable ADD INDEX(" + headers[i] + ");");
}

Thanks in advance,

Ed.
Report message to a moderator
[Message index]

Read Message
Read Message
Previous Topic:How to customize Query?
Next Topic:Slow MySQL on idle server
Goto Forum:

  

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]

Current Time: Fri Jul 10 00:49:17 EDT 2009

Total time taken to generate the page: 0.10652 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.7.
Copyright ©2001-2007 FUD Forum Bulletin Board Software

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.