Database activity logging and optimizations
Database activity logging and optimizations
- Subject: Database activity logging and optimizations
- From: "Karl Gretton" <email@hidden>
- Date: Thu, 6 Jan 2005 15:57:19 -0500
Hi,
We have a pure-WO-only
database (Sybase ASE) with approx 150 tables of which say 50 are enumeration/lookup
tables. This has been developed using WO best practices and therefore uses
meaningless int keys, etc.
It performs well right now
but we wish to now go to the next stage and do database specific optimizations.
Rather than just guess the
usage pattern and put the appropriate indexes in place, we would like to trap
queries that take more than x ms to exectute and log them and then analyze the
SQL to determine where indexes would be most appropriate.
Does anyone know where the
best place to capture this information, along with the related query, would be?
I am thinking somewhere in the EOAdaptor layer.
Karl
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden