Ankur,
Try turning off the table refreshes on open and see if it
still takes a long time. If it's the tables, then you need to look at your
table qualifications and try to slim the results down or chunk them. And
what I would do if it is the blobs that's causing your problem is move them
off to another table with an ID field to reference them. But, I'm
relatively new to this game, so I'm sure there are other, better ways.
Brian
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati
Sent: Wednesday, June 18, 2008 3:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: Unable to retrieve data from a form
**
Hi Guys,
Another thing which I forgot to mention, the status bar at the bottom does
show that it found the record and it gets stuck saying "Refreshing table up
to Administrator`s limit"
Ankur
_____
From: Ankur Gulati
Sent: 18 June 2008 03:30 PM
To: 'arslist@ARSLIST.ORG'
Subject: Unable to retrieve data from a form
Hi Listers,
We have a form which has 5 BLOB fields. There are around 67000 records and
it takes around 3-4 hrs to search for a single record. I search on the
request_id. We do have couple of other indexes in place apart on Request ID
field.
The actual workflow is that an AL does a push field and creates a new record
in a form and then second Set field is fired in same AL which opens this new
record in modify window. So this is where it fails to open this new record
and even if I open the form and search for any record it takes forever to
show up and usually it freezes.
I have rebuild the indexes but no improvement. On another form without no
BLOB data and 100+ fields, it takes less than a sec to search a record.
Logs doesn't show anything. AL, SQL and filter log just shows the perfect
creation of new record and then on Display it does show the opening of the
form in SET Operation.
What all should I check?
ARS. 7.0 Patch 5
Database Oracle 9i
Regards
Ankur
__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"
