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" <er**********@g mail.comwrote in message
news:11******** **************@ 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