<!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>If it makes any difference to the thread it is
currently single user. If the business takes off it could become
multi-user. So I'm glad to know that the Delete/Add field approach has
risks in a multi-user environment. Can the risk be eliminated by getting
exclusive access to the table before doing the Delete/Add?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</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=hsimpson88@hotmail.com href="mailto:hsimpson88@hotmail.com">Henry
Simpson</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 8:34
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] Update Query -
Need to Speed It Up</DIV>
<DIV><BR></DIV>Access is not used exclusively in multi user environments and
for those <BR>without fancy image processing or signal processing software, it
can be used <BR>to store and process 30 bit image scans and wav files quite
nicely as well <BR>as log all kinds of high frequency sampled data. For
example, if you want <BR>to drop a green cast out of the shadows and don't
have photoshop, it's a <BR>terrific tool, but you can do it in Access
too. If you want to reduce or <BR>increase the dynamic range of an audio
file that was poorly recorded, all <BR>you need to do is apply a scaling
factor to some numbers with an update <BR>query. My Canon D60 with a 5
megapixel ccd shoots typically 20 megabyte raw <BR>images and the Olympus P400
dye sub printer prints 7.7 megapixels on A4 <BR>paper. Although Access
is not as convenient as photoshop, a tool like <BR>Access is just another
means to manipulate data that encompasses more than <BR>merely Names,
addresses and phone numbers.<BR><BR>No doubt Rocky wouldn't be messing with
2.5 million records without reason <BR>and there is no reason to assume that
this would necessarily be a multi user <BR>environment. Such an
assumption in the face of the information given was
<BR>improbable.<BR><BR>Hen<BR><BR>_________________________________________________________________<BR>Help
STOP SPAM with the new MSN 8 and get 2 months FREE*
<BR>http://join.msn.com/?page=features/junkmail<BR>
<P>
<HR>
<P></P>
<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>