470,596 Members | 1,356 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

Access 97 is unacceptably slow for web application

Hi,

I have a small Access 97 database (~2.5 MB), which has about 9 user
tables, and data are normalized up to 3NF. I'm using a third party
tool/language for web interface application. I just did a quick test,
query runing from Access's internal SQL command line/window, very
fast, reasonably involved query (with three inner joins). So, the
problem seems to be on the third party tool side, maybe, it's
interaction with the driver is not that great.
Anything on Access side that I can do to improve the performance? All
tables's PKs have been indexed.

Thanks.
Nov 12 '05 #1
3 1930
sounds as if the problem is with the 3rd party tool - as you mentioned
the query is fast in MS Access, but slow via the web tool.......I
would check with the 3rd party tool.......possible a ODBC setting or
some other configuration

qw********@boxfrog.com (Doug Baroter) wrote in message news:<fc**************************@posting.google. com>...
Hi,

I have a small Access 97 database (~2.5 MB), which has about 9 user
tables, and data are normalized up to 3NF. I'm using a third party
tool/language for web interface application. I just did a quick test,
query runing from Access's internal SQL command line/window, very
fast, reasonably involved query (with three inner joins). So, the
problem seems to be on the third party tool side, maybe, it's
interaction with the driver is not that great.
Anything on Access side that I can do to improve the performance? All
tables's PKs have been indexed.

Thanks.

Nov 12 '05 #2
Watch out for indexed and nonindexed fields in your third party
software/setup. Using their nonindexed fields for joins can be very
slow. Look for names of fields that may have something like "Idx" as
part of the name, if the tables are already setup. If you are using
the Third Party software to set up your nonAccess tables, try to
index the fields you need to join on.

Peter

MeadeR wrote:
sounds as if the problem is with the 3rd party tool - as you mentioned
the query is fast in MS Access, but slow via the web tool.......I
would check with the 3rd party tool.......possible a ODBC setting or
some other configuration

qw********@boxfrog.com (Doug Baroter) wrote in message news:<fc**************************@posting.google. com>...
Hi,

I have a small Access 97 database (~2.5 MB), which has about 9 user
tables, and data are normalized up to 3NF. I'm using a third party
tool/language for web interface application. I just did a quick test,
query runing from Access's internal SQL command line/window, very
fast, reasonably involved query (with three inner joins). So, the
problem seems to be on the third party tool side, maybe, it's
interaction with the driver is not that great.
Anything on Access side that I can do to improve the performance? All
tables's PKs have been indexed.

Thanks.


Nov 12 '05 #3
Thanks you both. Yes, it seems to be obvious that the third party is
the culprit of the poor performance. They are doing something weird to
make ODBC to talk to its java server, an extra layer. But I consider
the problem solved since my client is using a lower version that does
not use Java and performance is OK.

qw********@boxfrog.com (Doug Baroter) wrote in message news:<fc**************************@posting.google. com>...
Hi,

I have a small Access 97 database (~2.5 MB), which has about 9 user
tables, and data are normalized up to 3NF. I'm using a third party
tool/language for web interface application. I just did a quick test,
query runing from Access's internal SQL command line/window, very
fast, reasonably involved query (with three inner joins). So, the
problem seems to be on the third party tool side, maybe, it's
interaction with the driver is not that great.
Anything on Access side that I can do to improve the performance? All
tables's PKs have been indexed.

Thanks.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Scott | last post: by
2 posts views Thread by egoldthwait | last post: by
4 posts views Thread by dorpnospam | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.