Re: dts quick to access 97 but slow to access 2003

I have noticed the network usage during this is excessive.
It's using 40% of the client and the file servers 100mbs connection network.
By my calculation, in the hour it runs for it could transfer 18Gb in that
time and it's only creating a 50Mb database.

The SQL Server itself is using a fraction of a percent - although it's page
file usage is 1gb and it only has 1gb of ram.

The CPU occupancy is nothing on the sql server, 30% on the file server and
60% on the client. That's a fair amount of processing over an hour too.


"Andrew Brill" <dragon@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:O1gwcDPxFHA.3860@xxxxxxxxxxxxxxxxxxxxxxx
> "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
> news:OIG$ZcOxFHA.2932@xxxxxxxxxxxxxxxxxxxxxxx
>> Jet driver differences?
>>
>
> Is there anything I can do about these differences?
> I note that it's quick if I use ODBC to connect to the database rather
> than setting Microsoft Access (with access 97 icon) as the Data Source.
> I'm not too familiar with ODBC but it looks like this unfortunately
> requires me to setup a DSN for every database file on every client
> machine.
>


.

Relevant Pages

  • Re: Image storage - db vs filesystem (again)
    ... Aaron Bertrand wrote: ... > We have web farms and the images are all stored on ... > data about each file is stored in the database. ... > to dozens of file servers, and one pair of databases in a cluster. ...
    (microsoft.public.sqlserver.programming)
  • Re: Problems with making hardlink-based backups
    ... About moving to database. ... The file servers themselves do have a large number of files... ... The problem is actually in the backup ... huge ram usage for large file lists, or other per-file data of some ...
    (Debian-User)
  • Re: ZFS melting under postgres...
    ... these are probably embedded appliances that don't get much storage ... I was thinking about different kind of servers - database, ... web or file servers. ...
    (freebsd-current)
Loading