Networker

Re: [Networker] Why is sscreate so slow?

2004-10-22 14:27:42
Subject: Re: [Networker] Why is sscreate so slow?
From: Darren Dunham <ddunham AT TAOS DOT COM>
To: NETWORKER AT LISTMAIL.TEMPLE DOT EDU
Date: Fri, 22 Oct 2004 11:45:33 -0700
>
> I've noticed that when I use 'sscreate' in an mminfo query, it takes a
> long time to complete. Something like:
>
> mminfo -s server -q 'client=clientname,sscreate>=10/01/04'
>
> runs and displays a bunch of stuff to the console and then hangs for a
> minute or so and then finally completes. I've tried this with various
> options, dates, clients,etc. However, if I instead run:
>
> mminfo -s server -q 'client=clientname,savetime>=10/01/04'
>
> then it runs lickidy split. Why is the use of sscreate such a hindrance?

One possibility is that 'savetime' is indexed within the database while
'sscreate' is not.  I don't know anything about the actual database
structure, so I can't verify it, but it seems plausible.

--
Darren Dunham                                           ddunham AT taos DOT com
Senior Technical Consultant         TAOS            http://www.taos.com/
Got some Dr Pepper?                           San Francisco, CA bay area
         < This line left intentionally blank to confuse you. >

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list. Questions regarding this list
should be sent to stan AT temple DOT edu
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>