May 2, 2008 at 12:23 am
Dear All,
I have to 2 DataBase DBMain and DBAudit,
All the Tables in the DBMain will be in the DBAudit allows
we are inserting one record in the DBAudit Table when any operation is done on the main table record (DBMain) such as delete,update and insert.
DBMain -TableA
DBAudit-[$TableA](this table contains all the colums of Table A and 3 more additional columns such as [$sessionid]$,[$Userid],[$Datetime])
No the Record count in the DBAudit table has crossed more than 5 lakhs. when the execute
select * from DBAudit.dbo.[$TableA]
it is taking more than 1 minutes to execute
is there any opition so the we can reduce the execution time.
please help me to solve this issue.
May 2, 2008 at 8:45 am
Hi,
Can I ask why would you want to return every one of the 500,000+ changes so far to a database table? Would you not just want to see the latest changes?
Cutting down the number of rows required would certainly speed up the request. :hehe:
May 2, 2008 at 9:04 am
Can you post the schema of the table please?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply