Thanks
Will ,,,=^. .^=,,,
Webmaster
* GreenNet========================================*
* "Link Locally ~ Surf Globally" http://www.greennet.net *
* Come Play On Our Game Server *
* Serving northeastern Massachusetts, southern New Hampshire *
* TEL: 508-363-8898 FAX: 508-363-1225 email:will@greennet.net*
*===============================================*
-----Original Message-----
From: Tom Bilan <tom@tdi.net>
To: emerald@emerald.iea.com <emerald@emerald.iea.com>
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
hardware.
>
>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
>
>Tom
>
>P.S. Let me know if you want the trigger, I'll post it.
>
>-----Original Message-----
>From: Mike Miller [SMTP:michael@abraxis.com]
>Sent: Thursday, July 31, 1997 12:02 PM
>To: emerald@emerald.iea.com
>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='206.155.199.52')
>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 michael@abraxis.com
>=================================================
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>