Sybase

[ankushc]

Hi,
How can i increase the speed os astored procedure in sybase.
Actualy i have a process which loads data from one table to another. This is done thrugh perl scripts which calls stored prcedures. This sp opens a cursor on a table , do's some processing on each record and the inserts into another table.
Now i want to increase the speed of transfer of this data.
How Can i do it??????????????????

[Clearcode]

Cursors are very slow.
Are you sure that your task cannot be done in one or more set based sql statements? i.e. What processing are you doing on each record?

HTH,
Duncan


-------------------------------------------------
Ex. Datis: Duncan Jones
Merrion Computing Ltd
http://www.merrioncomputing.com

[ankushc]

thanks for reply.

We are already using many sql statments to process business logics. Can anything else be done