Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

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



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com