SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 04:59 PM
| ||||
| ||||
 Rates of Change... Hi, Is there an easy way to determine the rate of change for table? I realize that I could do periodic select count(*) from XXX, but that would only determine the size of the table. It would ignore updates. What I'd really like to do would be able to determine the number of non-read operations over a table so that I can determine the rate of change for that table. Thanks for any help..      |
|
02-28-2008, 04:59 PM
| ||||
| ||||
| Re: Rates of Change... You could also create INSERT and UPDATE triggers on the table in question that would INSERT a record into a separate table. Everytime a record is inserted and updated a new record would be inserted into a history table. This may create performance issues which Erland's solutions do not. CJ "Madison Pruet" <mpruet@attbi.com> wrote in message news:wZkLa.42831$R73.7095@sccrnsc04... > Hi, > > Is there an easy way to determine the rate of change for table? I realize > that I could do periodic select count(*) from XXX, but that would only > determine the size of the table. It would ignore updates. > > What I'd really like to do would be able to determine the number of non-read > operations over a table so that I can determine the rate of change for that > table. > > Thanks for any help.. > > > |
 |
« Re: triggers with non existence table reference
|
Disadvantages of the implementation of explicit subtypes on MS SQL 7 and Oracle8i/9i »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 09:28 AM.
