Speeding up 97 clients

E

Everett

I currently have a 97 database running on a server with 27 clients. Recently
it has slowed to a crawl most of the time ( much to the pleasure of some fox
pro users). Talking to some folks they seem to think the size of the back end
is to large for access to handle (103,218kb). I have done some testing moving
the backend to the same machine as a client and it seems to run very quickly.
So it that would suggest it was a server or network bandwidth issue. any
thoughts on helping speed this up would be appreciated.

Thanks Everett

PS we cant let those fox pro guys win!
 
J

John Vinson

I currently have a 97 database running on a server with 27 clients. Recently
it has slowed to a crawl most of the time ( much to the pleasure of some fox
pro users). Talking to some folks they seem to think the size of the back end
is to large for access to handle (103,218kb). I have done some testing moving
the backend to the same machine as a client and it seems to run very quickly.
So it that would suggest it was a server or network bandwidth issue. any
thoughts on helping speed this up would be appreciated.
Click to expand...

Compact regularly of course; and make sure you have the appropriate
indexes on all fields used regularly for searching or sorting. There
are a lot of hints at Tony Toews' performance FAQ:

http://www.granite.ab.ca/access/performancefaq.htm
Thanks Everett

PS we cant let those fox pro guys win!
Click to expand...

<BG> Hey... some of my friends re FoxGang!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
A

Arvin Meyer

Everett said:
I currently have a 97 database running on a server with 27 clients. Recently
it has slowed to a crawl most of the time ( much to the pleasure of some fox
pro users). Talking to some folks they seem to think the size of the back end
is to large for access to handle (103,218kb). I have done some testing moving
the backend to the same machine as a client and it seems to run very quickly.
So it that would suggest it was a server or network bandwidth issue. any
thoughts on helping speed this up would be appreciated.
Click to expand...

Proper indexing, as John mentioned is probably the number 1 performance
enhancer. Since both FoxPro and Access use the same query technology
(Rushmore), I'd guess that the design is someone at fault. With proper
indexing 150K rows can be searched in a second, or less.

One other performance enhancer is aggregate (Totals) queries, and queries
with embedded functions. Gather and reduce your data with an initial query
and then run the aggregate or functions in a subsequent query. I've seen
this reduce time by a factor of 12.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
T

Tony Toews

Everett said:
I currently have a 97 database running on a server with 27 clients. Recently
it has slowed to a crawl most of the time ( much to the pleasure of some fox
pro users). Talking to some folks they seem to think the size of the back end
is to large for access to handle (103,218kb). I have done some testing moving
the backend to the same machine as a client and it seems to run very quickly.
So it that would suggest it was a server or network bandwidth issue. any
thoughts on helping speed this up would be appreciated.
Click to expand...

Suddenly slowed? Did the server change recently? Service pack on
the server? There is a problem with SMB signing. But there's a
link on the performance page already mentioned.

100 Mb is peanuts. There's a different problem somewhere.
PS we cant let those fox pro guys win!
Click to expand...

<chuckle>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top