ODBC is Slow!!??

I am trying to configure SQL*Net v2.0 for Windows on a Windows client running FTP Software's PC/TCP v2.3. I wrote an ODBC client program to do 1000 INSERTs into a 16 SMALLINT column table. The thing only averaged about 2 INSERTS/Second! I tweeked the network settings of PC/TCP and that didn't make that much difference.

My questions are these: (1) Is this normal speed for Oracle? and (2) Does anyone have any information that they've compiled about benchmark speeds for Windows clients?

Thanks in advance!

P.S. It's not our server. We are getting about 50 INSERTS/Second UNIX to UNIX over TCP/IP.

Leor Amikam Received on Tue Nov 08 1994 - 20:43:53 CET