[AccessD] Update Query - Need to Speed It Up

Better you than me, my friend. <g>  I had enough problems running
against 500,000 records on a dual processor machine.
 
Charlotte Foust

	-----Original Message-----
	From: Rocky Smolin - Beach Access Software
[mailto:bchacc at san.rr.com] 
	Sent: Monday, June 02, 2003 1:34 PM
	To: accessd at databaseadvisors.com
	Subject: Re: [AccessD] Update Query - Need to Speed It Up
	
	
	It runs okay, just a little pokey.  I've run bigger datasets
with Jet.
	 
	 
	Rocky
	 

		----- Original Message ----- 
		From: Charlotte Foust
<mailto:cfoust at infostatsystems.com>  
		To: accessd at databaseadvisors.com 
		Sent: Monday, June 02, 2003 2:23 PM
		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
			 
			 

		
  _____  


		

		_______________________________________________
		AccessD mailing list
		AccessD at databaseadvisors.com
		http://databaseadvisors.com/mailman/listinfo/accessd
		Website: http://www.databaseadvisors.com
		

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