| Why it is slow... [message #82553] |
Sat, 07 June 2003 01:53  |
Muzzammil
Messages: 99
Registered: February 2003
|
Member |
|
|
Hi,
I have many forms modules and reports.
When I make entries in Stock Form and Come to entry in Sales, Sales Form will take much time to retrive data from Sales. I am using Lov to retrive Month into Months field and 250 rows of data in Sales Block for data entry.
Always when I use one form or Report then othes will automaically gets slow.
Can anybody tell me why it happens,
Syed Muzzammil.
|
|
|
|
| Re: Why it is slow... [message #82554 is a reply to message #82553] |
Sat, 07 June 2003 05:33  |
Sun
Messages: 92
Registered: August 2002
|
Member |
|
|
|
Check your query.. If it is also slow then u have to change your query so that o/p can come fast. Make use of index and try..
|
|
|
|
| Re: Why it is slow... [message #83318 is a reply to message #82553] |
Tue, 23 September 2003 05:13 |
vimal
Messages: 46
Registered: February 2000
|
Member |
|
|
|
one suggestion from my side if in your query or subquery you are using function like sum(),nvl() please ignore this practice
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
