Re: [RadiusNT] Calls Performance

Dale E. Reed Jr. ( (no email) )
Sat, 07 Oct 2000 19:00:39 -0700

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

Unless you have a lot of indexes or a slow trigger, an insert should
never be slow. Also, you should NOT have a clustered index on your
calls table. If you do, your in for it. :(

Remove your trigger and see if it speeds it up. Remove unneeded
indexes as well.

-- 

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