[AccessD] Update Query - Need to Speed It Up

I don't think there is a limit on the number of records, just on the
database size.
 
Drew

-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Monday, June 02, 2003 4:23 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Update Query - Need to Speed It Up


Um, isn't that outside the specifications on maximum size for a Jet table?
Or are you running this against a SQL Server BE?
 
Charlotte Foust

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Monday, June 02, 2003 12:47 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Update Query - Need to Speed It Up


Dear List:
 
I am running an update query on a table with 2,500,000 records and it's
taking just a bit too long for the my and the client's liking.  
The SQL is:
 
UPDATE tblInvoiceDetail SET tblInvoiceDetail.fldInvoiceDetailPPV = """",
tblInvoiceDetail.fldInvoiceDetailVariancePercent = 0;
 
It's setting one field to blank the other to 0.
 
Is there a way to make it run any faster?
 
 
MTIA,
 
Rocky Smolin
Beach Access Software
 
 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030602/a05335a0/attachment-0001.html>