By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,491 Members | 3,230 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,491 IT Pros & Developers. It's quick & easy.

Slow calculation using ODBC

P: n/a
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

Jan 22 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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(ColumnName) 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**********@gmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.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

Jan 25 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.