[AccessD] Update Query - Need to Speed It Up

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


MessageIt runs okay, just a little pokey.  I've run bigger datasets with Jet.


Rocky

  ----- Original Message ----- 
  From: Charlotte Foust 
  To: accessd at databaseadvisors.com 
  Sent: Monday, June 02, 2003 2:23 PM
  Subject: RE: [AccessD] Update Query - Need to Speed It Up


  Um, isn't that outside the specifications on maximum size for a Jet table?  Or are you running this against a SQL Server BE?

  Charlotte Foust
    -----Original Message-----
    From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
    Sent: Monday, June 02, 2003 12:47 PM
    To: AccessD at databaseadvisors.com
    Subject: [AccessD] Update Query - Need to Speed It Up


    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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030602/2c156ed9/attachment-0001.html>


More information about the AccessD mailing list