How can i set the Query Processing Time in my asp page.
i am getting this error messages "Estimated query processing time 152
exceeds limit 30"
John
7  3799 
John Peter wrote: How can i set the Query Processing Time in my asp page.
i am getting this error messages "Estimated query processing time 152
exceeds limit 30"
John
You can try increasing the CommandTimeout property of your Connection or
Command object, but I would not stop there. You should talk to your AS400
operator about building indexes on the tables involved in your query so a
better query plan will be used. This is what helped when I encountered this
error a few weeks ago.
HTH,
Bob Barrows
Bob,
i tried changing value for CommandTimeout property but still error same
message.
The field on which i have my WHERE condition is not indexed and table has
about 700000 records and i can't index the table now.
can you suggest some thing else.
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... John Peter wrote: How can i set the Query Processing Time in my asp page.
i am getting this error messages "Estimated query processing time 152
exceeds limit 30"
John You can try increasing the CommandTimeout property of your Connection or
Command object, but I would not stop there. You should talk to your AS400
operator about building indexes on the tables involved in your query so a
better query plan will be used. This is what helped when I encountered
this error a few weeks ago.
HTH,
Bob Barrows
Code:-
Set DataConnFRP = Server.CreateObject("ADODB.Connection")
DataConnFRP.ConnectionTimeout = 20000
DataConnFRP.Open "DSN=my400;Uid=abc;Pwd=abc;"
Set ObjRSetFRP = Server.CreateObject("ADODB.Recordset")
ObjRSetFRP.CursorLocation = 3
ObjRSetFRP.Open "Select * from FRP where Acct = 1549" , DataConnFRP
Response.Write ObjRSetFRP.RecordCount
ObjRSetFRP.Close
Set ObjRSetFRP = Nothing
DataConnFRP.Close
Set DataConnFRP = Nothing
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:Ov**************@TK2MSFTNGP09.phx.gbl... What did you change it to? Where did you change it?
Let's see some code.
John Peter wrote: Bob,
i tried changing value for CommandTimeout property but still error
same message.
The field on which i have my WHERE condition is not indexed and table
has about 700000 records and i can't index the table now.
can you suggest some thing else.
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl... John Peter wrote:
How can i set the Query Processing Time in my asp page.
i am getting this error messages "Estimated query processing time
152 exceeds limit 30"
John
You can try increasing the CommandTimeout property of your
Connection or Command object, but I would not stop there. You should
talk to your AS400 operator about building indexes on the tables
involved in your query so a better query plan will be used. This is
what helped when I encountered this error a few weeks ago.
HTH,
Bob Barrows
I see where you set the ConnectionTimeout, which is totally irrelevant to
this problem. Where did you set the CommandTimeout?
Bob Barrows
John Peter wrote: Code:-
Set DataConnFRP = Server.CreateObject("ADODB.Connection")
DataConnFRP.ConnectionTimeout = 20000
DataConnFRP.Open "DSN=my400;Uid=abc;Pwd=abc;"
Set ObjRSetFRP = Server.CreateObject("ADODB.Recordset")
ObjRSetFRP.CursorLocation = 3
ObjRSetFRP.Open "Select * from FRP where Acct = 1549" , DataConnFRP
Response.Write ObjRSetFRP.RecordCount
ObjRSetFRP.Close
Set ObjRSetFRP = Nothing
DataConnFRP.Close
Set DataConnFRP = Nothing
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:Ov**************@TK2MSFTNGP09.phx.gbl... What did you change it to? Where did you change it?
Let's see some code.
John Peter wrote: Bob,
i tried changing value for CommandTimeout property but still error
same message.
The field on which i have my WHERE condition is not indexed and
table has about 700000 records and i can't index the table now.
can you suggest some thing else.
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
John Peter wrote:
> How can i set the Query Processing Time in my asp page.
> i am getting this error messages "Estimated query processing time
> 152 exceeds limit 30"
>
> John
You can try increasing the CommandTimeout property of your
Connection or Command object, but I would not stop there. You
should talk to your AS400 operator about building indexes on the
tables involved in your query so a better query plan will be used.
This is what helped when I encountered this error a few weeks ago.
HTH,
Bob Barrows
So where should i set the CommandTimeout and ConnectionTimeout?
John
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:Ow***************@tk2msftngp13.phx.gbl... I see where you set the ConnectionTimeout, which is totally irrelevant to
this problem. Where did you set the CommandTimeout?
Bob Barrows
John Peter wrote: Code:-
Set DataConnFRP = Server.CreateObject("ADODB.Connection")
DataConnFRP.ConnectionTimeout = 20000
DataConnFRP.Open "DSN=my400;Uid=abc;Pwd=abc;"
Set ObjRSetFRP = Server.CreateObject("ADODB.Recordset")
ObjRSetFRP.CursorLocation = 3
ObjRSetFRP.Open "Select * from FRP where Acct = 1549" , DataConnFRP
Response.Write ObjRSetFRP.RecordCount
ObjRSetFRP.Close
Set ObjRSetFRP = Nothing
DataConnFRP.Close
Set DataConnFRP = Nothing
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:Ov**************@TK2MSFTNGP09.phx.gbl... What did you change it to? Where did you change it?
Let's see some code.
John Peter wrote:
Bob,
i tried changing value for CommandTimeout property but still error
same message.
The field on which i have my WHERE condition is not indexed and
table has about 700000 records and i can't index the table now.
can you suggest some thing else.
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...
> John Peter wrote:
>> How can i set the Query Processing Time in my asp page.
>> i am getting this error messages "Estimated query processing time
>> 152 exceeds limit 30"
>>
>> John
> You can try increasing the CommandTimeout property of your
> Connection or Command object, but I would not stop there. You
> should talk to your AS400 operator about building indexes on the
> tables involved in your query so a better query plan will be used.
> This is what helped when I encountered this error a few weeks ago.
>
> HTH,
> Bob Barrows
You shouldn't need to set ConnectionTimeout. Set the CommandTimeout in the
same place you set the ConnectionTimeout. In other words, replace
"DataConnFRP.ConnectionTimeout = 20000" with "DataConnFRP.CommandTimeout =
20000" (or "DataConnFRP.CommandTimeout = 0" which tells it to never time
out). Again, the better thing to do is fix your query so it doesn't take so
long to execute.
HTH,
Bob Barrows
John Peter wrote: So where should i set the CommandTimeout and ConnectionTimeout?
John
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:Ow***************@tk2msftngp13.phx.gbl... I see where you set the ConnectionTimeout, which is totally
irrelevant to this problem. Where did you set the CommandTimeout?
Bob Barrows
John Peter wrote: Code:-
Set DataConnFRP = Server.CreateObject("ADODB.Connection")
DataConnFRP.ConnectionTimeout = 20000
DataConnFRP.Open "DSN=my400;Uid=abc;Pwd=abc;"
Set ObjRSetFRP = Server.CreateObject("ADODB.Recordset")
ObjRSetFRP.CursorLocation = 3
ObjRSetFRP.Open "Select * from FRP where Acct = 1549" , DataConnFRP
Response.Write ObjRSetFRP.RecordCount
ObjRSetFRP.Close
Set ObjRSetFRP = Nothing
DataConnFRP.Close
Set DataConnFRP = Nothing
"Bob Barrows" <re*******@yahoo.com> wrote in message
news:Ov**************@TK2MSFTNGP09.phx.gbl...
What did you change it to? Where did you change it?
Let's see some code.
John Peter wrote:
> Bob,
> i tried changing value for CommandTimeout property but still error
> same message.
> The field on which i have my WHERE condition is not indexed and
> table has about 700000 records and i can't index the table now.
> can you suggest some thing else.
>
>
> "Bob Barrows" <re*******@yahoo.com> wrote in message
> news:%2****************@tk2msftngp13.phx.gbl...
>> John Peter wrote:
>>> How can i set the Query Processing Time in my asp page.
>>> i am getting this error messages "Estimated query processing
>>> time 152 exceeds limit 30"
>>>
>>> John
>> You can try increasing the CommandTimeout property of your
>> Connection or Command object, but I would not stop there. You
>> should talk to your AS400 operator about building indexes on the
>> tables involved in your query so a better query plan will be
>> used. This is what helped when I encountered this error a few
>> weeks ago.
>>
>> HTH,
>> Bob Barrows
Bob,
I am just emphasizing with you.
Again, the better thing to do is fix your query so it doesn't take so
long to execute.
dlbjr
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Alex Satrapa |
last post by:
I have a table from which I'm trying to extract certain information. For
historical reasons, we archive every action on a particular thing
('thing' is identified, funnily enough, by 'id'). So the...
|
by: Passynkov, Vadim |
last post by:
I am using Asynchronous Query Processing interface from libpq library.
And I got some strange results on Solaris
My test select query is 'SELECT * from pg_user;'
and I use select system...
|
by: Együd Csaba |
last post by:
Hi All,
how can I improve the query performance in the following situation:
I have a big (4.5+ million rows) table. One query takes approx. 9 sec to
finish resulting ~10000 rows. But if I run...
|
by: Jeff Blee |
last post by:
I hope someone can help me get this graph outputing in proper order.
After help from Tom, I got a graph to display output from the previous
12 months and include the average of that output all in...
|
by: serge |
last post by:
How can I run a single SP by asking multiple sales question either
by using the logical operator AND for all the questions; or using
the logical operator OR for all the questions. So it's always...
|
by: Sam |
last post by:
Hi,
I have one table like :
MyTable {field1, field2, startdate, enddate}
I want to have the count of field1 between startdate and enddate, and
the count of field2 where field2 = 1 between...
|
by: SaltyBoat |
last post by:
Needing to import and parse data from a large PDF file into an Access
2002 table: I start by converted the PDF file to a html file. Then
I read this html text file, line by line, into a table...
|
by: dsdevonsomer |
last post by:
Hello friends,
I have one simple question. I have two tables. 1 ( Table A ) has about
2.5 million rows and second one ( Table B ) has about 1 million. There
are common ID fields in both tables. I...
|
by: jsacrey |
last post by:
Hey everybody, got a secnario for ya that I need a bit of help with.
Access 97 using linked tables from an SQL Server 2000 machine.
I've created a simple query using two tables joined by one...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
