[AccessD] Update Query - Need to Speed It Up

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Mon Jun 2 16:58:43 CDT 2003


8:10.  But with Erwin's filter 1:28.  Next stop, I guess is MSDE.

Rocky

  ----- Original Message ----- 
  From: Susan Harkins 
  To: accessd at databaseadvisors.com 
  Sent: Monday, June 02, 2003 2:08 PM
  Subject: Re: [AccessD] Update Query - Need to Speed It Up


  How long is too long? With 2 million records, and Jet, just how fast do you want it to be??? :) 

  And about that blank -- do you really mean a zero-length string or did you really want Null?

  Susan H. 


    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



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030602/59eff541/attachment-0001.html>


More information about the AccessD mailing list