Subject: Re: Unable to retrieve data from a form
**
From the User tool turn on logging (at least API and Database)
and see what SQL statement is the one taking so long
From: Action Request System discussion list
Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W
Sent: 18 June 2008 10:59 PM
To: arslist@ARSLIST.ORG
Subject: Re: Unable to retrieve data from a form
**
From the User tool turn on logging (at least API and Database) and see what
SQL statement
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
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
: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
*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
(Remedy defined), and User defined indexes.
Fred
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati
Sent: Wednesday, June 18, 2008 5:15 AM
To: arslist@ARSLIST.ORG
Subject: Re: Unable to retrieve data from a form
June 2008 07:31 PM
To: arslist@ARSLIST.ORG
Subject: Re: Unable to retrieve data from a form
**
What table do you have on the form? It still sounds like an
index problem (Either you are missing an index on the B table or your
selection query
)
[mailto:[EMAIL PROTECTED] On Behalf Of Ankur Gulati
Sent: 18 June 2008 08:08 PM
To: arslist@ARSLIST.ORG
Subject: Re: Unable to retrieve data from a form
**
Fred,
There are three tables on the form(Email handler Form
To: arslist@ARSLIST.ORG
Subject: Re: Unable to retrieve data from a form
Thank you for the script Fred,
All the concerned B Table indexes are coming up as Valid. The selection
query for the table does use indexed fields too.
Any other things I can check up
_
Ankur
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
11 matches
Mail list logo