You need to look at what the table field(s) are doing on that form. My guess is that they are pulling every record from the underlying table which is why it takes so long and often hangs.
On Wed, Jun 18, 2008 at 9:09 AM, Brian Gillock <[EMAIL PROTECTED]> wrote: > ** > > 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:* [email protected] > *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:* '[email protected]' > *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___ > __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"
