Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kienhow
Starting Member
2 Posts |
 Posted - 2008-03-08 : 03:20:33
|
| Hi all, I am a newbie on SQL Server.Currently I am having problem upgrading the performance of my program.I inner join a several tables (A,B,C,D) to get all the different IC number in my database.And i need to compare it with another table IC Number(E) for new IC number. If is new IC. I need to update the flag in that table (E).and continue with other processCurrently, I am using view, stored procedure and user defined function to do on this process.Due to the database size is growing. (Currently is around 1Gb) and I cannot reduce on the database size.. (Now I take around 2 hours to finish the compare on IC part)Anything thing I can do to improve on my performance?or I need to change my select data in view , sp or udf? |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2008-03-08 : 08:03:07
|
We can't answer that without seeing the code you are using.Are the IC numbers indexed on each table? presumably they are all unique? If you are using a UDF in your select statement, that would hinder performance somewhat. 1GB is pretty small and should be pretty fast. 2 hours is very slow for comparing 1 column.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Question (Sql server)