[AccessD] Update Query - Need to Speed It Up

Only in a single user environment....

In multi user your app can crash...


-----Oorspronkelijk bericht-----
Van: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Verzonden: dinsdag 3 juni 2003 6:05
Aan: accessd at databaseadvisors.com
Onderwerp: Re: [AccessD] Update Query - Need to Speed It Up


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
>


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