Scratch that, I just created a 100000 row table with 2 varchar255's. Creating a 2 col index on it took 2.09 seconds. Could take longer due to all the other fields you have in your table but a couple of minutes at the outside.
Dan On 11/17/06, Dan Buettner <[EMAIL PROTECTED]> wrote:
John, I would guess with about 100,000 rows, it might take a couple minutes to create an index on two varchar-255 columns. With modern hardware anyway. Very rough estimate. Factors include amount of RAM, speed of disks, speed of processors, other processes running and either locking table or just using resources. Do a SHOW PROCESSLIST; to see if your index creation is blocked. Dan On 11/17/06, John Kopanas <[EMAIL PROTECTED]> wrote: > I have a mysql table with 100K rows approximately. > > We are creating the following index: > create index closed_base_cust_and_job on backlog_dev.closed_bases(cust_no, > jobno); > > Both cust_no and jobno are varchars(255) > > There is 56 fields in the table and no other indeces except on the primary > key. > > Should it be taking a long time? How long would some estimate it takes? Is > there a way to estimate how long it takes? What factors affect the time it > takes to create an index? > > Thanks for your help. > > Your Friend, > > -- > John Kopanas > [EMAIL PROTECTED] > > http://www.kopanas.com > http://www.cusec.net > http://www.soen.info > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
