Slow calculation using ODBC

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • erick-flores
    #1

    Slow calculation using ODBC

    Hello all

    I have a linked table using ODBC. When I tried to do Count([total]) and
    Sum([total]) for this linked table (onw of the field in the table is
    name "total") the form takes forever to gives me the results, like 4
    minutes. I am putting a textbox in the footer of my form to get this
    results.
    The table has around 1300 records. Is there a better way to get quicker
    results?
    I know I can copy the linked table to my local computer and then the
    calculation will run faster but I dont want to do this because the
    table changes every minute.

    Any ideas???

    Thanks in advance

    Tags: None
    • '69 Camaro
      #2
      Re: Slow calculation using ODBC

      Hi, Erick.
      When I tried to do Count([total]) and
      Sum([total]) for this linked table (onw of the field in the table is
      name "total") the form takes forever to gives me the results, like 4
      minutes.
      It's a little faster if one uses COUNT(*) instead of COUNT(ColumnNam e) in
      the query.
      The table has around 1300 records. Is there a better way to get quicker
      results?
      Imagine how much slower it's going to be when there are 5,000 records, or
      when it has 10,000 records to pass across the network. This slowness with
      relatively few records is a clue that the network you're trying to cross is
      a very slow one (i.e., a WAN), or the computer you're connecting to is very
      slow, or the table's data structure is flawed. Ensure that the network is
      using 100 Mb Ethernet cables or faster, and that the database server is on a
      real server with appropriate database server hardware (not someone's spare
      desktop 166 MHz PC with 128 MB of RAM), and that the table being linked to
      has a primary key and appropriate indexes.

      HTH.
      Gunny

      See http://www.QBuilt.com for all your database needs.
      See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
      Blog: http://DataDevilDog.BlogSpot.com
      http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
      info.


      "erick-flores" <erickjflores@g mail.comwrote in message
      news:1169499650 .570184.245980@ v45g2000cwv.goo glegroups.com.. .
      Hello all
      >
      I have a linked table using ODBC. When I tried to do Count([total]) and
      Sum([total]) for this linked table (onw of the field in the table is
      name "total") the form takes forever to gives me the results, like 4
      minutes. I am putting a textbox in the footer of my form to get this
      results.
      The table has around 1300 records. Is there a better way to get quicker
      results?
      I know I can copy the linked table to my local computer and then the
      calculation will run faster but I dont want to do this because the
      table changes every minute.
      >
      Any ideas???
      >
      Thanks in advance
      >

        Comment

        Previous template Next
        Working...