Re: Windows 2003 slow serving dbf files

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Richard G. Harper (rgharper_at_email.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 19:00:14 -0400

This is probably to be expected. DBF files are often rather large, and
you're moving them down the network pipe at a speed that's 1/1000th (0.1%)
of the local hard drive's speed. As your queries are being processed at the
PC end of the pipe, that's a lot of data moving back and forth. 

-- 
Richard G. Harper [MVP Win9x]  rgharper@email.com
* PLEASE post all messages and replies in the newsgroups
* for the benefit of all.  Private mail is usually not replied to.
* HELP us help YOU ... http://www.dts-l.org/goodpost.htm
"RickG" <lumax@copper.net> wrote in message
news:40bcb48e_3@newsfeed.slurp.net...
> I just setup a new Windows 2003 server acting as a PDC for a small (7
> PC) network.  AD and DNS are running; DHCP has been turned off in an
> effort to troubleshoot...all PCs have a static IP.  The only use for
> this server is to hold a group of dbf files used by an
> accounting/inventory application.  This app is installed on each PC and
> accesses the DBF files on the server via ODBC using a mapped drive.
> Opening a list of invoices on a workstation takes a long time.  Doing
> the same using the application on the server is instant.  I tried
> mapping using the IP address of the server (rather than the name) but it
> did not help.  All hardware and cabling seem OK.
>
> The workstations are XP and Windows 98.  The server is using 2 7200
> Western Digital SATA drives in a RAID 1 configuration.
>
> Any ideas on how to speed this up?

Relevant Pages

  • Re: SBS 2003 SP1 disk filling up.
    ... I planned on moving the Exchange databases tomorrow. ... Moving Data Folders for Windows Small Business Server 2003 ... How to Move the Client Programs Folder to Another Location in Windows Small ...
    (microsoft.public.windows.server.sbs)
  • Re: Weird File Access Error
    ... When renaming or moving a file within the same partition, the contents of the file are not read, but when copying or moving to another partition, they are. ... I think it is important so I will mention again that I can change the file name with no problem, from user machine and from server. ... Check to see if they have quotas enabled on the drive of the server. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 SP1 disk filling up.
    ... I planned on moving the Exchange databases tomorrow. ... Moving Data Folders for Windows Small Business Server 2003 ... How to Move the Client Programs Folder to Another Location in Windows ...
    (microsoft.public.windows.server.sbs)
  • Re: New Sharepoint Install and DocIT
    ... Currently we are still moving from a Novell network to Active Directory. ... a company we have not made a firm decision on moving in to Windows 2003. ... > Services product or the chargeable product SharePoint Portal Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Office crashes at start-up
    ... If sometimes Office preferences are corrupted then we may come across such ... Try moving complete Microsoft folder from the above location to the desktop ... >I have been using Office v.X for a couple of years now on my Powerbook. ... if i need the server i of course have to ...
    (microsoft.public.mac.office)