[AccessD] Update Query - Need to Speed It Up

Henry Simpson hsimpson88 at hotmail.com
Mon Jun 2 18:31:33 CDT 2003


Delete the fields and add them back.  Default value "" and 0.

Hen


>From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
>Reply-To: accessd at databaseadvisors.com
>To: <AccessD at databaseadvisors.com>
>Subject: [AccessD] Update Query - Need to Speed It Up
>Date: Mon, 2 Jun 2003 13:47:27 -0700
>
>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

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail



More information about the AccessD mailing list