My response is: Buy more RAM!!!!! I know the world just found this funny, but several studies have shown that the largest cost of any Computer System in the last 15 - 20 years has been "people" cost and not hardware cost. ARS being a "high" Generation Language (GL) should be easier to maintain than the "low" end GLs (like SQL, Cobol, C, assembler). I would rank these as:
Machine Language -> 1 GL (good for landing on the moon in 1969, but not very maintainable) - Assembler -> 2 GL (Fast and more English like than Machine Language) - C -> 2.5 GL (bridges the gap between Assembler and 3 GL) - Cobol, Fortran, PL-1, Pascal -> 3 GL (more English like than 2 GL, but a little slower because of "templated" code (I'm not going to get into compiler theory)) - Adabase Natural Cognos Powerbuilder or Nomad -> 4 GL (more English like than 3 GL, but the same problems as a 3 GL) - SQL -> 4 GL (faster than ARS) - Remedy ARS -> 4.5 GL (GUI on top of SQL and more) - 5 GL - Artificial Intelligence assist (I don't believe this exists yet, except at MIT or other experimental organizations) ARS could do this with trend\statistical analysis built in. More RAM! - 6+ GL - "Data" from Star Trek the Next Generation or "Terminator" (whichever way you think) Hardware is now inexpensive and to improve performance by doing things in SQL, will bite you at some point (any eTang people out there?). Maintenance and documentation should always be considered when undertaking a task. Being a 4.5 GL, ARS tends to self-document also. Sounds like SLM is not very mature yet? If you have to "plug" speed code into it, then I would be a little wary of it at this point in time. Please understand, that I don't disagree with "Use what works best as the need dictates" because sometimes it is out of our control and we have to adapt. But I don't think this should be the rule. You purchased Remedy ARS for a reason. Use it! The paradigm has to shift. Too often management will look at the task and don't look at the overall people cost. The Higher the GL the less costly the maintenance. This has been true since Grace Hopper first pulled the moth out of the Enniac at University of PA. Consultants love this paradigm because they will always come out over budget. Computer Science has fallen behind reality. Hardware costs are not the major cost anymore. Heck, there's still textbooks that say the Cocomo model is the best way to size a system. Try a LOC count on a Remedy System? Are there any Computer Scientists anymore or are they all Microsoft certified engineers? Oh and by the way, if you are connecting to the T-Table, you'd better update the H-Tables, B-Tables, etc. as well. If you don't consider this you will have a mess. That's enough for today, :) Gordon M. Frank -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Friday, September 19, 2008 10:27 AM To: [email protected] Subject: Re: Inserting data in the T table directly from the database. Because its much faster in some cases, possibly by an order of magnitude > 10. Use what works best as the need dictates. BMC does direct sql stuff via jdbc with their SLM product. Axton Grams On Fri, Sep 19, 2008 at 8:50 AM, Frank, Gordon M. (CMS/CTR) <[EMAIL PROTECTED]> wrote: > ** > > To be Frank, > > > > Why would you want to do this? > > > > In a secondary question, why did you purchase the Remedy ARS product, if you > are going to perform SQL anyways? > > > > The ARS and its 4.5 GL interface is a very good and eliminate the need to > perform manual SQL. I have yet to see a system which the ARS can not handle. > > > > Have you tried the ODBC interface? > > > > I see these types of posts all the time and I have to ask, "If you want a > low level SQL or API interface, why did you purchase BMC Remedy Action > Request System?" If built correctly, BMC Remedy ARS should save you in > "developer maintenance" costs. > > > > On another note and to be helpful rather than critical, if you are going to > update T Tables directly, you had better be very, very, very familiar with > the Database Reference. Version 7.1 has a Database reference called, "BMC > Remedy Action Request System 7.1.00 Database Reference." It can be found on > the BMC SupportWeb. > > > > Gordon M. Frank > > Lockheed Martin > > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of manoj jain > Sent: Friday, September 19, 2008 8:26 AM > To: [email protected] > Subject: Re: Inserting data in the T table directly from the database. > > > > ** > > Hi, > > > > I have checked this in my side value is reflecting in my side fill all the > require field(Core field) > then try again . > > > > Bye, > > Manoj Jain > > > On 9/19/08, Anuj DUA <[EMAIL PROTECTED]> wrote: > > Hi, > > I am trying to insert data into T table directly from the database. I have > also inserted the values (ENTRYID) in the respective H table. But the data > is not getting reflected in the form. > > If anyone has any idea of this, pls share. > > > With Regards, > Anuj Dua > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
