250MB file - how long to load (Enterprise Edition)

D x?}VkoÜ6ü®_±?¸ùîò?ÛyØ ?káÆiRýHI{a?¼?ò¯ïìJ>ûZ8@àèÅáìììð?â?0?Lm°¾¥¨c)w6Ñ&??ú??¹3??gÚrLÁS5dÊ{?ÄñÆ? ¬Ã©â?ñ'ÓÎænÂJö?icӏ?ÛhS?äC.iíicê|??

Given the size of the file it would not not surprise me if it took that long to load on a standalone machine.

Unfortunately Terminal Services is not an option right now. The $$ for the licenses are just not available. Everything does work when it comes up, it just takes a while. I do realize that may be the only option as the database grows, though.

Gary

One of my tests today will be to put a copy of the file onto a standalone system and see how long it takes to come up. If it's substantially the same then I'm probably going to tell the company owner that he just needs to accept the load time.

If you already own Windows 2003 Server, Terminal Services is already built in. All you need is a TS CAL for each user ( Unfortunately Terminal Services is not an option right now. The $$ for the

FYI everyone -

I adjusted the server parameters to allocate 512MB of RAM for file I/O and set the system to keep the core operating system code in RAM at all times rather than allow it to be paged.

Results: The time required to load the database and get QuickBooks going on the 1 Gbit/sec attached workstation went from 75 seconds (average) to 15 seconds (average). The time for the slowest system went from 360 seconds (average) to 60 seconds (average).

Worth doin'!

Gary

I have a new client who's using the latest version of QB Enterprise. They have 10 people using one file pretty much all of the time doing the typical things one does in QB. The QB file is about 250 MB, has recently been checked out by Quicken and verified to be OK. I'm not terribly familiar with QuickBooks Enterprise and 10 users - most of my clients who use QB have 1 or

2 users so I'm looking for some assistance on file load times.

They're using Windows Server 2003 on the server - it has gobs of RAM and a fast SCSI RAID subsystem. Server NIC and Ethernet switch is 1 Gbit/sec. The server has very low CPU utilization and low network traffic.

The user PCs are mostly 1.8 GHz Pentium 4 processors with 512MB RAM with 100 Mb/sec NICs. One is a 3.2 GHz with 1 Gbit/sec NIC.

In any case the owner of the company feels that the 60 to 120 seconds it takes to load the file once one has entered one's user name / password is too long (that's the time until the QB user interface is back under the user's control, hourglass is gone, etc.).

I notice that most of the network traffic occurs in the first 20 or so seconds after one enters ones password but there is a "dribble" of network traffic that goes for the remainder until everything is loaded. I'm wondering if that could be reports of some kind being regenerated / updated or ??

Is this amount of time reasonable or should I be looking for a way to decrease the file load time?

Thanks in advance for any thoughts on the matter.

Gary

That's interesting info. Thanks for posting.

Mike Schumann

Gary,

Where did you make this change? I've looked & looked...

John

Gary wrote:

Sorry for the delay in posting back.

To keep the core operating system files in RAM see:

or google "disablepagingexecutive"

To increase the RAM allocated for file I/O buffer see:

or google "iopagelocklimit"

These are registry changes. I believe they require a restart of the server to take effect.

Made a HUGE difference in performance of QuickBooks.

/gary

Where did you make this change? I've looked & looked...

John

Gary wrote: