>
> 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
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
|