Personal computing discussed

Moderators: Steel, notfred

 
michael_d
Gerbil Elite
Topic Author
Posts: 563
Joined: Sun Dec 16, 2007 2:42 pm

Solution for Intermittent Delays while viewing/entering data

Mon Mar 01, 2010 3:51 pm

Hardware:
Server - Athlon II 630 2.80, 4GB of RAM, W2K8 32-bit, NIC 1Gb
W/S - various CPUs, 2/4GB of RAM, XP Pro, NIC - 100Mb

Software:
Client/Server based application runs on MS Access

Problem:
Intermittent Delays lasting upto 30 secs while entering and/or viewing information on w/s.

Any help would be appreciated.
Last edited by michael_d on Sat Mar 06, 2010 5:04 pm, edited 1 time in total.
Alienware: Core i7 960 3.2GHz | 12GB RAM | 1.5TB HD | EVGA GTX Titan X | Dell WFP 3008 30" 2560x1600 | Windows 10 Pro 64 Bit
 
Nitrodist
Grand Gerbil Poohbah
Posts: 3281
Joined: Wed Jul 19, 2006 1:51 am
Location: Minnesota

Re: Intermittent Delays while viewing/entering data

Mon Mar 01, 2010 5:58 pm

How large is the database?
Image
 
UberGerbil
Grand Admiral Gerbil
Posts: 10173
Joined: Thu Jun 19, 2003 3:11 pm

Re: Intermittent Delays while viewing/entering data

Mon Mar 01, 2010 6:07 pm

Nitrodist wrote:
How large is the database?
And how many simultaneous users of the database, particularly updating users?
 
michael_d
Gerbil Elite
Topic Author
Posts: 563
Joined: Sun Dec 16, 2007 2:42 pm

Re: Intermittent Delays while viewing/entering data

Tue Mar 02, 2010 9:55 am

UberGerbil wrote:
Nitrodist wrote:
How large is the database?
And how many simultaneous users of the database, particularly updating users?


-Number of users less than 10
-DB size is around 80MB
Alienware: Core i7 960 3.2GHz | 12GB RAM | 1.5TB HD | EVGA GTX Titan X | Dell WFP 3008 30" 2560x1600 | Windows 10 Pro 64 Bit
 
michael_d
Gerbil Elite
Topic Author
Posts: 563
Joined: Sun Dec 16, 2007 2:42 pm

Re: Intermittent Delays while viewing/entering data

Sat Mar 06, 2010 5:03 pm

Solution found for those who may encounter the same problem. Quick Books 2010 SQL Server has a conflict with MS Access Database Management application if they run on the same server which would cause performance dips in MS Access application. They simply need to be installed on separate servers.
Alienware: Core i7 960 3.2GHz | 12GB RAM | 1.5TB HD | EVGA GTX Titan X | Dell WFP 3008 30" 2560x1600 | Windows 10 Pro 64 Bit
 
titan
Grand Gerbil Poohbah
Posts: 3314
Joined: Mon Feb 18, 2002 7:00 pm
Location: Great Smoky Mountains
Contact:

Re: Solution for Intermittent Delays while viewing/entering data

Sun Mar 07, 2010 9:32 pm

That's a workaround, not a solution. :evil:
The best things in life are free.
http://www.gentoo.org
Guy 1: Surely, you will fold with me.
Guy 2: Alright, but don't call me Shirley.

Who is online

Users browsing this forum: Baidu [Spider] and 2 guests