Re: [RadiusNT] Calls Performance

sci ( (no email) )
Sat, 7 Oct 2000 11:35:52 +0500

heres what i did when i reach 3.5+ million rows in Calls and on Insert, i
was getting Timeout Expired.

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." <>
To: <>
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
> > 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.
> For more information about this list (including removal) go to:

For more information about this list (including removal) go to: