Absolutely. I have changed many search menu's into sql menus simply for the
performance gain. To use a value from a selection list, keep in mind that
the value stored in the database is the number of the selection. And off
the top of my head, I think it doesn't read it right, so you have to do the
conversion. Which really shouldn't be that hard.

If there is anything I can do to help, just send me your info offline.

Brian

brian.goralczyk@verizonwireless.com

-----Original Message-----
From: jjmckenzie51@earthlink.net [mailto:jjmckenzie51@EARTHLINK.NET]
Sent: Monday, December 31, 2001 10:28 AM
Subject: Re: Server Specifications


**

Brian:

I'll test this as we need to pull back information on a particular form.
This may prove very helpful. Have you tried this with a user selectable
list field to provide input?

James Mckenzie

Original Message:
-----------------
From: Brian Goralczyk Brian.Goralczyk@VERIZONWIRELESS.COM
Date: Mon, 31 Dec 2001 09:12:56 -0500
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: Re: Server Specifications


**

You can also do sql searches instead.
Just do select from
where upper() like upper()
|| '%'
This will cause a case insensitive search.

Plus I find sql searches are much quicker and pull less data. If you create
a search menu in remedy and put a sort on it, you pull 4 fields of data.
Where as in a sql menu you only pull one or two fields of data.

-----Original Message-----
From: Lisa Bryant [mailto:Lisa.Bryant@COMPASSBNK.COM]
Sent: Friday, December 28, 2001 4:59 PM
Subject: Re: Server Specifications


**

Just one minor note I'm sure you are already aware of.....Oracle is case
sensitive. That can be a pain in doing certain kinds of searches. We are
on Oracle here, and there are several instances where case sensitivity
really hurts.

Lisa Bryant
Compass Bank

>>> mjmaxson@NISOURCE.COM 12/28/01 01:39PM >>>
**

All,

I am trying to get some ideas for a server specification. Can you help?
Below are the details of what we will have:

120 licenses -- 40 fixed 80 floating. About 100-105 concurrent users
ARS 4.5.2
HelpDesk 4.0.3
Change Management
The AR Server must be an WINNT/WIN2K box.

The database will be an oracle 8.0.6 database on AIX Unix (unless anyone
has a reason to go with SQL Server and NT/2000).



We are also geographically dispersed across the midwest and north east.
Would you all have a single server? Would you use multiple servers and
dso?

Thanks for the help.

Matt

__________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

__________________
_____________


You may also control your subscription options, including UNSUBSCRIBE, at
www.ARSLIST.org

--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .

__

You may also control your subscription options, including UNSUBSCRIBE, at www.ARSLIST.org