Re: [Emerald] consolidation
Will LaSala ( firstname.lastname@example.org )
Mon, 7 Dec 1998 09:48:06 -0500
>Will LaSala wrote:
>> 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 ,,,=^. .^=,,,
"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:email@example.com