Hi Experts,

One Report output coming very very slow approximately 20 min in 900 compnay but in 700 compnay its takes only 1 or 2 sec.

can u please guide me what should i do in this case.


thanks and regards
yogesh

Hi Experts,

One Report output coming very very slow approximately 20 min in 900 compnay but in 700 compnay its takes only 1 or 2 sec.

can u please guide me what should i do in this case.


thanks and regards
yogesh

Hello,
looks like 700 is in SM and 900 not ?
Regards

Hi Experts,

One Report output coming very very slow approximately 20 min in 900 compnay but in 700 compnay its takes only 1 or 2 sec.

can u please guide me what should i do in this case.


thanks and regards
yogesh

Hello,
looks like 700 is in SM and 900 not ?

Or the used tables are with and without table booster.

Regards

Hi Bernd,

Can you please explain me in detail. what the step should i flow to overcome this. Because i developed so many reports but this is the first report in which this problem come.

Hi Bernd,

Can you please explain me in detail. what the step should i flow to overcome this. Because i developed so many reports but this is the first report in which this problem come.

Hello,
as you said, it's an own dev. report. This is difficult to say where are the problem with your report.
Try to analyse the DB performance with b-shell runtime debug options to see where the query spend the time.

The trace file should show you the time consumption.

Regards

What is the size of the data in both the companies ?

I would also say check the indexes in both companies for the tables. Using the debug options as bernd suggested will help. Of course as also mentioned - the amount of data can also be the cause, especially if indexes are not used correctly. So you may want to make sure the data sets are about the same size.

Thanks for your reply,

but when i further investigate i found very interesting fact

1. if i login with super user like bsp, baan then reports coming with in 1 or 2 sec in both the company.

2. but when i login with other normal user then report getting too slow in 900 company but coming very fast in 700.

please help me what should i do....

This means the data in 900 company is large and u are probably using field level validations on related tables in 900 which can make working of normal user slow.