Shafqat, I will only try to address this one part of your questions:
<IMHO> "and how to display something like a half million tickets intelligently?" There are exactly zero known ways to do this in a tabular form. (Which is the best a table field in ARS can do for you.) There are ways to build summary reports. However, most of those are still not "intelligent" when your dealing with that kind of volume. Most humans can only really focus on a few simultaneous things at a time. Anything over say a couple of hundred (semi-simultaneous things) is well beyond most peoples abilities. Spend your efforts trying to figure out what the users want and why they think they want it instead of working on a performance/technical issue. They will be much happier with the results. Even though you likely will have to drag them kicking and screaming to the final solution. </IMHO> Good luck. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. Never ascribe to malice, that which can be explained by incompetence. On 5/2/06, Shafqat Ayaz <[EMAIL PROTECTED]> wrote:
** Hi List any bright ideas? I need to have a CP and show entries from 48 forms? trying to have join forms is going to be extremely painful! each form can have hundreds of thousands entries, and the users want to see a consolidated list. I could create a form and have just the main details of each ticket as a ticket on this form, any other way? and how to display something like a half million tickets intelligently? ARS 5.2 Sybase 12.5.2 Mid-Tier 6.5 kind regards shafqat ayaz Shafqat Ayaz ________________________________ Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2ยข/min or less. __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
