[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/84fb4210/attachment-0001.html>