Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server Performance Tuning Interview Questions > Sql server Performance is slow

:: Categories ::

Interview Question in SQL Server Performance Tuning


 

Interview Question :: Sql server Performance is slow


i m using sql server 2000 and VB 6.0 as front end.
i have a table named tblCompany in which company information is stored. when i open recordset and save it and apply rs.requery method then it take long time to complete the transaction. i have 50000 rows what can i do? please help me
Answers to "Sql server Performance is slow"
RE: Sql server Performance is slow?

I am assuming you have indexes set on the table? Is there a unique identifier?



Do you really need to requery for the entire 50k rows? Something sounds fishy there to me. Are you populating a grid or something, that will take some time.



Maybe try using a stored procedure to do your requery instead. You should pick up a bit of performance from that.



Just a couple of thoughts.
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License