Click here to Skip to main content
14,934,026 members
Home / Discussions / Database
   

Database

 
GeneralRe: Logging Pin
Blue_Boy28-Aug-09 5:04
MemberBlue_Boy28-Aug-09 5:04 
GeneralRe: Logging Pin
Ashfield28-Aug-09 8:18
MemberAshfield28-Aug-09 8:18 
GeneralRe: Logging Pin
cdpace28-Aug-09 11:25
Membercdpace28-Aug-09 11:25 
GeneralRe: Logging Pin
Ashfield29-Aug-09 3:57
MemberAshfield29-Aug-09 3:57 
GeneralRe: Logging Pin
εїзεїзεїз30-Aug-09 20:37
Memberεїзεїзεїз30-Aug-09 20:37 
GeneralRe: Logging Pin
Ashfield31-Aug-09 2:42
MemberAshfield31-Aug-09 2:42 
GeneralRe: Logging Pin
εїзεїзεїз5-Sep-09 22:18
Memberεїзεїзεїз5-Sep-09 22:18 
GeneralRe: Logging Pin
Ashfield6-Sep-09 21:19
MemberAshfield6-Sep-09 21:19 
So you used a generic logging system and it slowed your system. No big suprise there. As I said, we use triggers for auditing and have never had performance issues, but we write them ourselves so they are optimised for our system, with the audit tables properly located and indexed etc.

You may have had a bad experience with triggers, but do not assume they are bad, its just a case of using them properly - I have no experience of ApexSQLAudit, but I wouldn't expect some generic product to be as performant as one written specifically for your database by someone who knows what they are doing.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

AnswerRe: Logging Pin
εїзεїзεїз30-Aug-09 20:36
Memberεїзεїзεїз30-Aug-09 20:36 
QuestionHelp writing query Pin
michaelgr128-Aug-09 2:04
Membermichaelgr128-Aug-09 2:04 
AnswerRe: Help writing query Pin
Mycroft Holmes29-Aug-09 15:22
professionalMycroft Holmes29-Aug-09 15:22 
QuestionSQL:Problem in dynamic sql query [modified] Pin
xodeblack27-Aug-09 22:37
Memberxodeblack27-Aug-09 22:37 
AnswerRe: SQL:Problem in dynamic sql query Pin
Mycroft Holmes28-Aug-09 0:45
professionalMycroft Holmes28-Aug-09 0:45 
QuestionPlease suggest Pin
ME_Learner27-Aug-09 20:25
MemberME_Learner27-Aug-09 20:25 
AnswerRe: Please suggest Pin
Mycroft Holmes28-Aug-09 0:50
professionalMycroft Holmes28-Aug-09 0:50 
AnswerConsider Data Partioning Pin
David Mujica28-Aug-09 2:48
MemberDavid Mujica28-Aug-09 2:48 
Question## in sql server..? Pin
DIPAK@EMSYS27-Aug-09 19:57
MemberDIPAK@EMSYS27-Aug-09 19:57 
AnswerRe: ## in sql server..? Pin
Ashfield27-Aug-09 20:56
MemberAshfield27-Aug-09 20:56 
AnswerRe: ## in sql server..? Pin
Coding C#28-Aug-09 1:58
MemberCoding C#28-Aug-09 1:58 
Questiondesign questions - tables to support users Pin
Kimmmmy27-Aug-09 9:58
MemberKimmmmy27-Aug-09 9:58 
AnswerRe: design questions - tables to support users Pin
Luc Pattyn27-Aug-09 10:57
sitebuilderLuc Pattyn27-Aug-09 10:57 
GeneralRe: design questions - tables to support users Pin
Kimmmmy27-Aug-09 12:04
MemberKimmmmy27-Aug-09 12:04 
GeneralRe: design questions - tables to support users Pin
Luc Pattyn27-Aug-09 12:29
sitebuilderLuc Pattyn27-Aug-09 12:29 
GeneralRe: design questions - tables to support users Pin
Kimmmmy27-Aug-09 12:38
MemberKimmmmy27-Aug-09 12:38 
GeneralRe: design questions - tables to support users Pin
Mycroft Holmes27-Aug-09 14:34
professionalMycroft Holmes27-Aug-09 14:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.