Re: Anyone have any tips to speed up SQL querys?

Will LaSala ( )
Thu, 31 Jul 1997 12:31:01 -0400

I'd love to see this trigger 'cause I hate losing my calls history
everytime I have to consolidate!
Plus I lose the info for my customers when they want to check there call

Will ,,,=^. .^=,,,
* GreenNet========================================*
* "Link Locally ~ Surf Globally" *
* Come Play On Our Game Server *
* Serving northeastern Massachusetts, southern New Hampshire *
* TEL: 508-363-8898 FAX: 508-363-1225*

-----Original Message-----
From: Tom Bilan <>
To: <>
Date: Thursday, July 31, 1997 12:26 PM
Subject: RE: Anyone have any tips to speed up SQL querys?

>I created a trigger for inserting on the CALLS table that inserts just
AcctStatusType = 2
>messages and a limited number of fields (5 I think) so that the data was
small and fast.
>I now can consolidate without losing my call history and I run reports off
of that table
>instead of the larger CALLS table.
>Also, you can move your tempdb into RAM but you need to have the extra
>Also, use the fastest drive you can possible find. I use an Ultra/Wide
Barracuda for
>my database drive and things seem to chug along relatively smoothly.
>My .02
>P.S. Let me know if you want the trigger, I'll post it.
>-----Original Message-----
>From: Mike Miller []
>Sent: Thursday, July 31, 1997 12:02 PM
>Subject: Anyone have any tips to speed up SQL querys?
>Hello all:
>Does anyone have any tips to speed up SQL querys? I have set up a query
>in MSQuery to assist us in tracking down spammers. Basically it takes
>an IP address and lists all logins/logouts for that address during a
>specified time period. The problem is it takes about 10 to 15 minutes
>to generate the report. I want to incorporate the query into a web
>based idc, but attempting to do so results in a timeout while waiting on
>the results from the server.
>The query:
>SELECT Calls.CallDate, Calls.UserName, Calls.AcctStatusType
>FROM "Emerald2.dbo".Calls Calls
>WHERE (Calls.CallDate>={ts '1997-07-30 00:00:00'} And Calls.CallDate<{ts
>'1997-07-31 00:00:00'}) AND (Calls.FramedAddress='')
>ORDER BY Calls.CallDate
>Emerald configuration:
>System: NT Server 4.0, Pentium 133, 24 MB RAM
>The operating system and SQL server are on one SCSI hard disk, while the
>SQL database is on another SCSI hard disk to increase speed.
>Emerald has been running for about 2 months. We have not consolidated
>as of yet as I was hoping to keep at least a month of records for this
>purpose. Our user base is around 1000. Emerald is being used for
>accounting only on most of our ports, however is used for authentication
>and accounting on a handful of our X2 ports. The database is currently
>using about 76MB of space to store the records.
>Does anyone have any suggestions to speed up this query and/or our
>Emerald server?
> /\ Mike A. Miller
> /--\ \/ Abraxis Networks
>/ \ B R A /\ I S
> /
> N E T W O R K S
> ----------------------------------------------------------
> Emerald Mailing List