[AccessD] Update Query - Need to Speed It Up

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Mon Jun 2 23:05:14 CDT 2003


That might cut it down to 5 seconds.  Have to get out the old ADH and look
up that adding and dropping fields code.

Thanks for the idea.

Rocky

----- Original Message ----- 
From: "Henry Simpson" <hsimpson88 at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, June 02, 2003 4:31 PM
Subject: Re: [AccessD] Update Query - Need to Speed It Up


> 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
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list