Re: [Emerald] consolidation

Will LaSala ( will@greennet.net )
Mon, 7 Dec 1998 09:48:06 -0500

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Hector Cintron: "[Emerald] Problem with RadiusNT & Emerald"
Next message: Jeff Woods: "[Emerald] Emerald 2.5: Invoices paid?"
Maybe in reply to: Tommy Cheng: "[Emerald] consolidation"

>Will LaSala wrote:
>>
>> Tommy,
>> 207 fixes the consolidation part I think.
>> I've got it summarizing at least, I'm going to test the rest of it later
>> this afternoon.
>> BUT The summary really seemed to tax the server.
>
>Make sure you have an index in your Calls Table for the Status and
>CallDate fields. If you don't have one of the Status field, it
>will do a table scan, which can take a while. There wasn't any
>issues with the consolidation, that I know of.

Dale,
I added the appropriate indexes but it still takes about 10 minutes to get
the summary up.
Any more suggestions?
Will ,,,=^. .^=,,,
Webmaster
GreenNet® ==========================================
"Link Locally ~ Surf Globally©" http://www.greennet.net
Come Play On The Best Quake Server in the Northeast
Serving Eastern Massachusetts and Southern New Hampshire
TEL: 978-363-8898 FAX: 978-363-1225 email:will@greennet.net
===================================================

Previous message: Hector Cintron: "[Emerald] Problem with RadiusNT & Emerald"
Next message: Jeff Woods: "[Emerald] Emerald 2.5: Invoices paid?"
Maybe in reply to: Tommy Cheng: "[Emerald] consolidation"