Update & Insert Speed

[MarcoSpain]

I'm using ASE 12.0.3 in a SUN 420 with a SUN solaris cluster.
I have a procedure that inserts to a table, this procedure is call from an external program, the lengh of the packet are 512. The maximun rate of insert that i can get is of 110-120 per second and this is really low. Can anyone help me to solve this problem.
thanks a lot
regards

 

[qyllr]

hello,

check your indexes... generally, inserts, updates, deletes take longer when large numbers of indexes need to be updated...

try to analyze your insert also by doing a showplan...

not having all the details of your project, i would recommend hitting a clustered index from the tables you are accessing to improve performance and minimize your table scans...

you mentioned that you are running a script outside of sybase... if this is true... you may be using drivers to execute your script that can slow you down... try writing a shell script and use isql inside your script to execute your insert... and avoid the drivers...

1. you can be sure that your performance issue is only in sybase and not in unix or a combination of both...

2. you have room for error checking...

3. you are more portable with your scripts and not dependent on your drivers...

hope this helps,
q.