Very Computer

1. ADO win 95 speed issue - NT has no problem

We're using ADO to retrieve and update tables in a SQL Server 7
database.  We keep the connection to SQL Server open throughout the
system, so we don't have a speed issue with reconnecting.

We open the ADO connection with a SELECT command to obtain one record.
Then change 22 fields in the record.

With rsData
        !ShopNumber = miShopNumber
        !ShopName = msShopName
....
and update it following update to the fields:

     .Update

When the update is performed on a 95 machine with 128Mbyte of memory
there is a lag of 1 second and the CPU usage goes to 100%.
An NT machine with same Processor and memory barely registers the
activity.

On another 15 field update it's about the same.

The final cherry on the cake is a stored procedure call, involving 3
fields.

This pushes the CPU on the 95 machine to 100% for 1.5 seconds and the
NT machine barely registers it.

All three calls result in about a 3 second delay on a 95 machine with
450Mhz processor and 128Mbyte of RAM.  The NT machine displays it in
the blink of an eye.

The two machines are next to each other on the same network.
Ping times to the server are consistenly between 1ms and 8ms on both
machines.

Both machines are using EXACTLY the same app, ADO is 2.5 on both
machines.  We're using Visual Basic 6.

Does anyone have any ideas why the 95 machine would be so much slower?
Is it purely an operating system architecture problem that I just won't
be able to overcome?  Thus requiring an NT upgrade on the 95 machine?

Cheers

Andrew

Sent via Deja.com http://www.deja.com/
Before you buy.

2. C++ wrappers for ctlib??

3. NT Workstation connects faster than Win 95

4. London/City - Visual FoxPro Team Leader - Wanted

5. 24007-NJ-Warren-PC-Windows 95-Windows NT-SYBASE-Windows NT-ORACLE-Crystal Info-Programmer

6. Repl over 1MB line over 80 kms

7. 24321-FL-TAMPA/ST. PETERSBURG-C-Windows 95-Windows NT-SQL-TCP/IP-C, Windows 95, Windows NT, SQL, TCP/IP

8. Copying LONGS as part of a DR Solution