I have a database that isn't very big. It has about 2400 rows in it.

I try and do an update like this one below (it looks big, but it's

really not if you look at it) :

UPDATE jobs

SET prodduedate = '1/5/2005', clientduedate = '1/5/2005', digitizingcnd

= 'x', digitizingcndnonsub = '', digitizingintl = '', retrieval = '',

wellsitetape = '', boardsubmissions = '', hardcopylogs = '', burningcd

= '', las20 = '', metric = '', tops = '', custsupplogs = '', email =

'', bhcscax = 'x', bhcscay = 'x', bhcsgr = 'x', bhcsdt = 'x',

dipoledtsm = 'x', dipoledtco = 'x', dilsp = 'x', dilim = 'x', dilid =

'x', dilfr = 'x', mlin1 = 'x', mln02 = 'x', mlcal = 'x', arraysp = 'x',

arrayat10 = 'x', arrayat20 = 'x', arrayat30 = 'x', arrayat60 = 'x',

arrayat90 = 'x', arrayat120 = 'x', arrayrxoz = 'x', elsp = 'x', elsn =

'x', elln = 'x', ellt = 'x', ielsp = 'x', ielsn = 'x', ielid = 'x',

ielic = 'x', ielres = 'x', cnfdcax = 'x', cnfdcay = 'x',cnfdgr = 'x',

cnfdden = 'x', cnfdrhob = 'x', cnfdrhoz = 'x', cnfddc = 'x', cnfddrho =

'x', cnfdhdra = 'x', cnfdnphilime = 'x', cnfdnphisand = 'x',

cnfddphilime = 'x', cnfddphisand = 'x', cnfdpef = 'x', cnfdpefz = 'x',

cnfdrop = 'x', cnfdtotalgas = 'x', notes = '', nologs = 0, nocurves =

47, footageout = 33, overdue = 197, totaldays = 244, headerprep = '',

digitizing = '', edit = '', output = '', rejected = '', fixed = '',

rejectreason = '', query = '', answer = '', dccurves = '', dccharges =

'', dcfeet = '', dicurves = '', dicharges = '', difeet = '', dtcurves =

'', dtcharges = '', dtfeet = '', rcurves = '', rcharges = '', rfeet =

'', wcurves = '', wcharges = '', wfeet = '', hclogs = '', hccharges =

'', hcfeet = ''

WHERE jobnumber = 4010

As you can see it looks huge, but really it's just editing one row in

the database and updateing many fields.

I've tested this update and it takes :

1 minute 26 seconds to do the update when there are 2400 rows in the

table.

25 seconds to do the update when there are only 1200 rows in the table

and 7 seconds to do the update when there are 600 rows int he table.

Either way, all of those updates are taking way to long. I'd assume

the update should be well under a second for each.

I know what you're thinking. I didn't use indexes. I did in fact put

an index on "jobnumber" (where there are no duplicates within that

field).

I only have the one index on that field.

I know for a fact that it's not a network issue. The network is fast

and opening the database from anywhere is very fast.

Anyone see anything I could be doing work or just overlooking?

Any help at all is greatly appreciated. I can't seem to find much at

all on this on google :(

TIA!

Ryan