1.copy the DB to a temp DB.
11. generate script for calls table and all related object from DB.
2. create run a script to rename Calls Table and all its related objects
like PrimaryKey and Indexes.
test the rename script on Master DB, then run the Create script to create a
new Calls Table and all related object.
IMPORTANT: recompile the triggers on calls table.
that's it.
using this way u dont lose the old calls data.
:)
- sci
----- Original Message -----
From: "Dale E. Reed Jr." <daler@iea-software.com>
To: <radiusnt@iea-software.com>
Sent: Saturday, October 07, 2000 3:01 AM
Subject: Re: [RadiusNT] Calls Performance
> Tom Pipes wrote:
> >
> > My calls table has a terrible response time. All other tables perform
> > excellent. Even when I stop my radius service the calls performance is
> > unsatisfactory. I need to purge the calls occasionally, but it is
> > difficult to keep up with when it takes so long. I reindexed on the
> > "calldate", but it did not seem to make a difference (with the thought
that
> > my index was possibly a problem).
>
> Terrible response time doing what? Inserting, updating, deleting?
> What query are you running? One query on a table can take 4ms,
> whereas a similar wone can take 4 hours. Without really understanding
> what you are doing (and with what DB), its tough for someone to
> give you advise.
>
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT/X
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart