Access 97 is unacceptably slow for web application

[Doug Baroter]

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.

[MeadeR]

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.

[Peter Flick]

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.

[Doug Baroter]

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.