<html><div style='background-color:'><DIV>
<P>whew...2.5million records- there's your problem! Have you tried a maketable (create a new one delete the old) setting those fields when you do it? WAG..I know. Other than that how about setting some temporary indices (indexes) on those fields...might help.<BR>_D<BR></P></DIV><BR><BR><BR>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Rocky Smolin - Beach Access Software" <BCHACC@SAN.RR.COM>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: [AccessD] Update Query - Need to Speed It Up
<DIV></DIV>>Date: Mon, 2 Jun 2003 13:47:27 -0700
<DIV></DIV>>
<DIV></DIV>>Dear List:
<DIV></DIV>>
<DIV></DIV>>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.
<DIV></DIV>>The SQL is:
<DIV></DIV>>
<DIV></DIV>>UPDATE tblInvoiceDetail SET tblInvoiceDetail.fldInvoiceDetailPPV = """", tblInvoiceDetail.fldInvoiceDetailVariancePercent = 0;
<DIV></DIV>>
<DIV></DIV>>It's setting one field to blank the other to 0.
<DIV></DIV>>
<DIV></DIV>>Is there a way to make it run any faster?
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>MTIA,
<DIV></DIV>>
<DIV></DIV>>Rocky Smolin
<DIV></DIV>>Beach Access Software
<DIV></DIV>>
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></div><br clear=all><hr>MSN 8 with <a href="http://g.msn.com/8HMFENUS/2740??PS=">e-mail virus protection service: </a> 2 months FREE*</html>