<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Don:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I thought about doing it for the two fields I'm
updating. But then the report would have to do a one-to-one join on the
table with the two fields instead of just printing the two bound fields on the
report. Not sure I'd save anything that way.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Right now the UPDATE time is tolerable.
There's another chunk of code after that which compares the detail records to
find the variances which can take several minutes to run. That's where I'm
going to look for a different technique.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>For the moment - client is happy!!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks to all who gave me input on this
problem.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access Software</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=delliker@hotmail.com href="mailto:delliker@hotmail.com">Don
Elliker</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, June 03, 2003 6:18
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Update Query -
Need to Speed It Up</DIV>
<DIV><BR></DIV>
<DIV>
<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*
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>