Re: [Emerald] consolidation

Will LaSala ( )
Mon, 7 Dec 1998 09:48:06 -0500

>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.

I added the appropriate indexes but it still takes about 10 minutes to get
the summary up.
Any more suggestions?
Will ,,,=^. .^=,,,
GreenNet® ==========================================
"Link Locally ~ Surf Globally©"
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