[AccessD] Update Query - Need to Speed It Up

MessageOf course there's a limit on the number of records.  Everything is
based around long integers (for counting things) so if nothing else the
number of records would be 2^31 which can't be realized anyway since the
file size limit would already be reached.
John W. Colby
www.colbyconsulting.com

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka
  Sent: Monday, June 02, 2003 5:46 PM
  To: 'accessd at databaseadvisors.com'
  Subject: RE: [AccessD] Update Query - Need to Speed It Up


  I don't think there is a limit on the number of records, just on the
database size.

  Drew
    -----Original Message-----
    From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
    Sent: Monday, June 02, 2003 4:23 PM
    To: accessd at databaseadvisors.com
    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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030602/1f0f39e8/attachment-0001.html>