|
Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006
Storage slow process of implementation, which will be installed changed?
Storing slow implementation of Sybase System, which will be installed changed? |
This is a very extensive then, the procedure can be found which is the slow implementation of SQL?
If the procedure on his print "Hello Sybase!" will be very slow? |
I would like to ask the database is set up with a relationship?, The vernier more storage process. |
Generally, the multi-use Vernier traversal? Generally speaking, there is probably no more than 3,000 firms? |
Far more than |
Vernier is very slow, and may have to switch to other means to improve |
Please make sure the statistics were updated.
Then you can investigate furthur. |
Look at the plan with showplan |
Sybase System features cursor is far less efficient operation tempdb Lane lines faster.
So you changed the process, the temporary table, no cursor as well. |
Many factors affect the performance of the first database parameters of the reasons for exclusion, if feasible, it has to lock debugging : data, indexing, tempdb, one must analyze more than 3,000 firms, Leiya |
Cursor speed is very slow and may point circle okay |
| |