Get a reporting server and crystal enterprise that would be the ideal solution. Other that limit access to the reporting ser and limit query chunk size Sent from my Verizon Wireless BlackBerry
-----Original Message----- From: B A <a.g.bryan...@gmail.com> Date: Sat, 18 Jul 2009 00:06:06 To: <arslist@ARSLIST.ORG> Subject: Re: Performnace Issue Due To Report Fetching Are any of the bind variable referring to a user? a.g.bryan.14 On 7/17/09, manoj jain <manoj.jain4...@gmail.com> wrote: > > ** Hi Remedians, > > I need some suggesstions from your side related to performance issue. > Our DBA team got one query due to this query performance issue occuring. > > *Query:* > ** > > *High I/O query* > > * * > > *SELECT*T28.C1,C600011000,C536870984,C536870913,C900106001,C901050057,C536871019,C900200400,C536870958,C536870950,C900170325,C536870935,C900100003,C536870929,C536870931,C536870914,C536871018,C536870938,C650000000,C536870952,C536871025,C536871038,C536900000,C536870912,C7,C900040206,C901092014,C900110076,C536870987,C901170021 > *FROM* T28 *WHERE* (((T28.C112 *LIKE* :"SYS_B_00") *OR* ((T28.C112 > *LIKE*:"SYS_B_01") > *OR* ((T28.C112 *LIKE* :"SYS_B_02") *OR* ((T28.C112 *LIKE* :"SYS_B_03") * > OR* ((T28.C112 *LIKE* :"SYS_B_04") *OR* ((T28.C112 *LIKE* :"SYS_B_05") *OR > * ((T28.C112 *LIKE* :"SYS_B_06") *OR* (T28.C112 *LIKE* :"SYS_B_07")))))))) > *AND* (((((((T28.C536871018 < :"SYS_B_08") *AND* ((T28.C650000000 > *LIKE*:"SYS_B_09") > *OR* (T28.C650000000 *LIKE* :"SYS_B_10"))) *AND* (T28.C536871019 *IS* * > NULL*)) *AND* (((T28.C536870938 >= :"SYS_B_11") *AND* (T28.C536870938 <= > (:"SYS_B_12" + ((:"SYS_B_13" * :"SYS_B_14") * :"SYS_B_15")))) > *OR*((T28.C900110022 >= :"SYS_B_16") > *AND* (T28.C900110022 < (:"SYS_B_17" + ((:"SYS_B_18" * :"SYS_B_19") * > :"SYS_B_20")))))) *OR* (((T28.C536870984 = :"SYS_B_21") *AND*(T28.C536871019 > *IS* *NULL*)) *AND* ((T28.C900110022 >= :"SYS_B_22") *AND* (T28.C900110022 > < (:"SYS_B_23" + ((:"SYS_B_24" * :"SYS_B_25") * :"SYS_B_26")))))) > *AND*(T28.C7 != :"SYS_B_27")) > *AND* (T28.C7 != :"SYS_B_28"))) *ORDER* *BY* :"SYS_B_29" *ASC* > > > > *T28 is Report form* > > > > So the problem is that number of users try to fetch report simultaneously > from the server. > > > > So what could be the solution for this? > > > > Thanks & Regards, > > Manoj Jain >_Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"