Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / May 2008

Tip: Looking for answers? Try searching our database.

3 machines, same application, different speed results

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Salad - 02 May 2008 16:26 GMT
I have an app on three different machines; front end on the PC, backend
on the network.

These are my results on loading the application when I press OK from the
Logon form (username/pw) to presenting the opening form and finishing
running setup routines.

On the old machine (4 yrs old). Win2000.  Dell.  1 gig memory
    A97 (backend A97 format) 7-8 seconds
    A2003 (backend A97 format) 12-14 seconds
    A2003 (backend A2003 format) 8-9 seconds

2 new machines.  XP.  2 gigs ram.  Dell.
    A2003 (backend A97 format)  25 seconds to load on each.

A2003 is service pack 2.  All computers use the same desktop icon.

Both new machines are extremely slow on opening and going into various
forms.  They're on the same network, same  backend file as the old
machine.  They use Norton AntiVirus.

The backend resides on a Novell file server.

Any ideas on what could cause the new computer load time to almost
double in time compared to the old machine?  I would think a faster
processor and more memory would make them faster.
Bruce - 02 May 2008 16:44 GMT
> I have an app on three different machines; front end on the PC, backend
> on the network.
[quoted text clipped - 22 lines]
> double in time compared to the old machine?  I would think a faster
> processor and more memory would make them faster.

All other things being equal, I'd say it's Win2000 vs. WinXP when
accessing a Netware server.  It would be interesting to see if you
experience the same problem by putting the back end on one of your new
XP machines and then testing the front end on the old Win2000 versus
the front end on the second new WinXP machine (thus eliminating Novell
as the possible culprit) while connecting to the back end on the first
XP machine using simple file sharing.

Bruce
Salad - 03 May 2008 16:10 GMT
>>I have an app on three different machines; front end on the PC, backend
>>on the network.
[quoted text clipped - 32 lines]
>
> Bruce

Thanks, Bruce.  I will check this out.  I definitely need to see if
there's a difference between the two.  I'll post my results later.
Salad - 06 May 2008 15:31 GMT
>>> I have an app on three different machines; front end on the PC, backend
>>> on the network.
[quoted text clipped - 35 lines]
> Thanks, Bruce.  I will check this out.  I definitely need to see if
> there's a difference between the two.  I'll post my results later.

You could have knocked me over with a feather on Sunday.  I opened the
new XP machine and the main form displayed in 3-4 seconds, all load
processes complete.  Same thing on many tests.  Hurray!

Then I opened the app on another machine and it went back to a typical
slow load of 25-30 seconds.  Bummer.

I got in contact with their network guy and we hashed some things out.
I asked him to check on NortonAV...they have the corporate edition.  He
stopped the scanning on MDB files.  When he did that it dropped the load
time back to 3-4 seconds.  Hurray!
lyle fairfield - 06 May 2008 15:58 GMT
Which is worse, Necrotizing Fasciitis or Norton Anythingitis?

> I got in contact with their network guy and we hashed some things out.
> I asked him to check on NortonAV...they have the corporate edition.  He
> stopped the scanning on MDB files.  When he did that it dropped the load
> time back to 3-4 seconds.  Hurray!
Salad - 06 May 2008 16:57 GMT
> Which is worse, Necrotizing Fasciitis or Norton Anythingitis?

:)  With my luck I'd contact Dracunculiasis after drinking Symantec
kool-aide.

>>I got in contact with their network guy and we hashed some things out.
>>I asked him to check on NortonAV...they have the corporate edition.  He
>>stopped the scanning on MDB files.  When he did that it dropped the load
>>time back to 3-4 seconds.  Hurray!
Marco Pagliero - 02 May 2008 22:37 GMT
> Both new machines are extremely slow on opening and going into various
> forms.  They're on the same network, same  backend file as the old
> machine.  They use Norton AntiVirus.
What are the load times without Norton?

Marco P
Salad - 03 May 2008 16:09 GMT
>>Both new machines are extremely slow on opening and going into various
>>forms.  They're on the same network, same  backend file as the old
[quoted text clipped - 3 lines]
>
> Marco P

I will check.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.