Sybase : slow using 32 bit - fast using 16 bit 
Author Message
 Sybase : slow using 32 bit - fast using 16 bit

We have an existing application which runs well under 16 bit.  It was
originally developed for win31 using d1.  The typical config was a pentium
75 w/ 8MB ram.  Queries were via the intersolve odbc (CT-LIB).

After conversion to native sybase 32 bit (D3),  the query speed went from
15s to 57s.  Upgrading the users PC to 32 MB improved performance to around
25 s.  Still slower than than the old 16 bit app on an 8 MB machine.

Is there any fix for this 'downgrade'

Regards
Peter



Wed, 18 Jun 1902 08:00:00 GMT  
 Sybase : slow using 32 bit - fast using 16 bit
I had a similar expririence.  The slow down is due to the fact that
inter-process communication takes a context switch in 95 an NT.  This is
relatively slow, but necessary because now all programs have their own
separate address space.  The only thing to do about that is to reduce the
not the amount of communication, but certainly the number of communications
made.  Many small communications are you bottleneck.  See if you can
somehow group them to send them in batch.
--
Van den Driessche Willy




Quote:
> We have an existing application which runs well under 16 bit.  It was
> originally developed for win31 using d1.  The typical config was a
pentium
> 75 w/ 8MB ram.  Queries were via the intersolve odbc (CT-LIB).

> After conversion to native sybase 32 bit (D3),  the query speed went from
> 15s to 57s.  Upgrading the users PC to 32 MB improved performance to
around
> 25 s.  Still slower than than the old 16 bit app on an 8 MB machine.

> Is there any fix for this 'downgrade'

> Regards
> Peter



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Using a 32 bit DLL in a 16 bit BPW application

2. Using 32 bit DLL in 16 bit BPW application

3. Convert 32 bit component to 16 bit ??

4. BDE 32-bit & 16-bit

5. 16 bit ODBC drivers in the 32 bit environment

6. 32 bit bde with 16 bit odbc

7. CRC 16-bit and 32-bit

8. Delphi/BDE 16 bit VS 32 bit

9. Upgrade 16-bit application to 32-bit

10. Upgrade 16-bit application to 32-bit

11. 16-bit to 32-bit

12. 16-bit Application and 32-bit ODBC

 

 
Powered by phpBB® Forum Software